Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Push SQL 2008 data to MYSQL via SSIS Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 2:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Hi all

I am trying to use SSIS to push data to MYSQL.
I can do this using a ADO .NET connection and a MySQL provider. It doesn't however allow me to see existing tables in the mysql db. SSIS creates a new table on creation of the package.

How do I get it to map to an existing MYSQL table. Iam using VS 2008.
Post #1352049
Posted Thursday, August 30, 2012 2:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Do I simply need to change SQL mode on MYSL
Post #1352054
Posted Friday, August 31, 2012 1:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224
Anbody got any ideas?
Post #1352629
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse