![]() Once designed, these ‘packages’ are compiled into ‘.dtsx’ packages which can then be distributed and run on any machine with the SSIS tools installed. ![]() SSIS provides a graphical front end to design control flow data processing logic. ![]() MySQL Connector/ODBC 5.1 (Which is already installed, in our previous article) SQL Server Business Intelligence Development StudioĬonnector/Net is a fully-managed ADO.NET driver for MySQL. In this article I will discuss about creating a SSIS package to transfer data from MS SQL Server 2008 to MySQL 5.5 However, it is just the basic step to try and bring two different RDBMS systems linked together. In my previous article I had created linked server, to access and query a database.
0 Comments
Leave a Reply. |