Cannot ETL data to MySQL using SSIS2008

  • Panaflax
  • Topic Author
  • Visitor
  • Visitor
13 years 4 months ago #715 by Panaflax
Cannot ETL data to MySQL using SSIS2008 was created by Panaflax
Deleting original text because I'm an idiot.

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

More
13 years 4 months ago #716 by Moderator
Replied by Moderator on 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.

  • Panaflax
  • Topic Author
  • Visitor
  • Visitor
13 years 4 months ago #718 by Panaflax
Replied by Panaflax on 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.137 seconds
Powered by Kunena Forum