- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- How correctly to convert datetime to timestamp
How correctly to convert datetime to timestamp
- rodyushkin
- Topic Author
- Visitor
-
9 years 1 month ago #9919
by rodyushkin
How correctly to convert datetime to timestamp was created 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?
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
-
9 years 1 month ago #9920
by rodyushkin
Replied by rodyushkin on 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.
9 years 1 month ago #9923
by Moderator
Replied by Moderator on 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.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- How correctly to convert datetime to timestamp
Time to create page: 0.072 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- How correctly to convert datetime to timestamp