How correctly to convert datetime to timestamp

  • rodyushkin
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago #9919 by rodyushkin
I have tried to use OLEDB connection (trial version for Greenplum) in SSIS package for copying table (MS SQL to Greenplum) operation, but I got error: "PostgreSQL Native Provider" Hresult: 0x80004005 Description: "ERROR: insufficient data left in message".
It is a big table not only because rows but columns (almost 100 columns). With good working varchar(s) and int(s) there are a lot of datetime(s) in source. Is it a problem? What can suggestions be made for this error?

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

  • rodyushkin
  • Topic Author
  • Visitor
  • Visitor
9 years 1 month ago #9920 by rodyushkin
It is important that GPLOAD option was used.

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

More
9 years 1 month ago #9923 by Moderator
Could you send the SQL Server and Postgres tables DDLs to help us reproduce the issue? The DDLs can be e-mailed to support at pgoledb.com. Thank you!

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

Time to create page: 0.072 seconds
Powered by Kunena Forum