How correctly to convert datetime to timestamp

More
7 years 2 weeks ago #9919 by rodyushkin
rodyushkin created the topic: How correctly to convert datetime to timestamp
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.

More
7 years 2 weeks ago #9920 by rodyushkin
rodyushkin replied the topic: Re: How correctly to convert datetime to timestamp
It is important that GPLOAD option was used.

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

More
7 years 1 week ago #9923 by Moderator
Moderator replied the topic: Re: How correctly to convert datetime to timestamp
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.077 seconds
Powered by Kunena Forum