Cannot ETL data to MySQL using SSIS2008

More
9 years 7 months ago #715 by Panaflax
Panaflax created the topic: Cannot ETL data to MySQL using SSIS2008
Deleting original text because I'm an idiot.

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #716 by Moderator
Moderator replied the topic: Re: Cannot ETL data to MySQL using SSIS2008
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?

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #718 by Panaflax
Panaflax replied the topic: Re: Cannot ETL data to MySQL using SSIS2008
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).

Please Log in or Create an account to join the conversation.

Time to create page: 0.103 seconds
Powered by Kunena Forum