Cannot ETL data to MySQL using SSIS2008
3 posts
• Page 1 of 1
Cannot ETL data to MySQL using SSIS2008
by 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
by 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?
Please send us the table schema and test package. Are you using MySQL OLEDB Provider? Have you tried to use SQL Server source?
-
Moderator - Site Admin
- Posts: 235
- Joined: Wed Oct 29, 2008 11:27 pm
Re: Cannot ETL data to MySQL using SSIS2008
by 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
3 posts
• Page 1 of 1
Return to SQL Server/DTS/SSIS/Linked servers/Replication
Who is online
Users browsing this forum: No registered users and 2 guests