How correctly to convert datetime to timestamp

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

How correctly to convert datetime to timestamp

Postby rodyushkin » Wed May 08, 2013 11:50 pm

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?
rodyushkin
 
Posts: 2
Joined: Wed May 08, 2013 11:33 pm

Re: How correctly to convert datetime to timestamp

Postby rodyushkin » Thu May 09, 2013 12:08 am

It is important that GPLOAD option was used.
rodyushkin
 
Posts: 2
Joined: Wed May 08, 2013 11:33 pm

Re: How correctly to convert datetime to timestamp

Postby Moderator » Tue May 14, 2013 9:51 pm

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!
User avatar
Moderator
Site Admin
 
Posts: 310
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests

cron