Cannot ETL data to MySQL using SSIS2008

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Cannot ETL data to MySQL using SSIS2008

Postby Panaflax » Wed Dec 08, 2010 7:32 am

Deleting original text because I'm an idiot.
Last edited by Panaflax on Wed Dec 08, 2010 9:11 am, edited 1 time in total.
Panaflax
 
Posts: 2
Joined: Wed Dec 08, 2010 5:33 am

Re: Cannot ETL data to MySQL using SSIS2008

Postby Moderator » Wed Dec 08, 2010 8:47 am

Could you run PGNProfiler.exe as Administrator (it is a module of PGNP)? Please select "localhost" on the left and see what are the error messages in the trace window.

Please send us the table schema and test package. Are you using MySQL OLEDB Provider? Have you tried to use SQL Server source?
User avatar
Moderator
Site Admin
 
Posts: 310
Joined: Wed Oct 29, 2008 11:27 pm

Re: Cannot ETL data to MySQL using SSIS2008

Postby Panaflax » Wed Dec 08, 2010 9:09 am

Sorry , please ignore this stupid bug report. I just inherited a package from a previous developer which consolidates data from SQL2005 and PostGres into a MySQL database. The problem is not with the PostGres driver, its with MySQL. I cannot see the wood for the trees today. Apologies! (I'll chase up with the MySQL people).
Panaflax
 
Posts: 2
Joined: Wed Dec 08, 2010 5:33 am


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest

cron