question

Murali avatar image
Murali asked

ssis package to import date from LINUX Box to SQL Server2008

The MySQL Database is available on Linux Server and in MySQL i have two databases from which i need to import the data to SQL Server 2008 which is on Windows 2003 Server. I need to Schedule a Job for this. How can i achieve this by using SSIS Package. Any help Please.....
sql-server-2008ssismysqllinux
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Andy Leonard avatar image
Andy Leonard answered
You can use SQL Agent on the SQL Server 2008 server to schedule a job. Connect to the SQL Server 2008 instance using SSMS. In Object Explorer, expand SQL Server Agent. Right-click Jobs and create a new job. Name the job and click the Steps page. Click the New button to add a new step. Name it and set the type to Integration Services. Configure the items on the General tab, aiming them at your SSIS package. Click the Schedules page and set up a schedule to execute the job periodically. Hope this helps, Andy
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

i am not asking for a scheduling of the job ...i am asking for by using SSIS package....by using which component or control we can import date from LINUX OS (which is having two databases) to SQL Server (SQL Server is on Windows 2003 Server).
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
If you are new to SSIS then check [SSIS tutorials][1]. If your concerns are regarding Automating SSIS - Assuming you have deployed the SSIS package to the package store or file system, you can automate the package by using SQL Server Agent Jobs. To call SSIS package on SQL Jobs you should must create a Proxy Account and the Credential. Note the Credential should have the necessary privilege on both Servers and DBs. Refer [Scheduling SSIS Package with SQL Server Agent][2] for more details regarding Scheduling. [1]: http://www.mssqltips.com/tutorial.asp?tutorial=200 [2]: http://www.mssqltips.com/tutorial.asp?tutorial=220
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

i am asking for by using SSIS package....by using which component or control we can import date from LINUX OS (which is having two databases) to SQL Server (SQL Server is on Windows 2003 Server).
0 Likes 0 ·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Hi as @Cyborg wrote, check the SSIS Tutorials. But anyway to transfer any kind of data you use a Data Flow Task. Inside the Data Flow Task put a OLE DB Source for connecting to the MySQL using OLE DB Driver or ADO NET Source if connecting to MySQL using ODBC drivers. As a target for connecting to the SQL Server 2008 Instance use OLE DB Destination Of course, you need to install appropriate drivers for MySQL. Eg. OLE DB Drivers and/or at least ODBC Driver, configure ODBC to use it. The drivers needs to be installed on the machine on which the SSIS package will be executed. Also you have to remember potential issues if you will be running the packages on x64 machine. Then you need x64 drivers or run the packages in x32 mode.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
Another solution would be to use [MySQL Compare from Redgate][1] to copy the schema across, you could then dump the table contents from MySQL to CSV files and use SSIS to read the files into the newly created tables in SQL Server. That shouldn't be too difficult. [1]: http://www.red-gate.com/products/sql-development/mysql-compare/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.