Lost rows?

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

Lost rows?

Postby rvallee » Thu Mar 24, 2011 7:53 am

MSSQL 2005
VS 2005-SSIS package
latest pgoledb drivers (bought and paid 2 weeks ago)

I have created a simple SSIS package that uses a query as a source (PG), in the middle I have a Data Transformation object (very simple string to int types), and the OLE destination is MSSQL 2005. The package runs without errors or issues but, for some reason I am not getting all the rows (short by 1090 rows). I have tried it with\without the middle piece (Data Transformation ) with the same results.

Any ideas?

Rob
rvallee
 
Posts: 4
Joined: Tue Mar 15, 2011 8:05 am

Re: Lost rows?

Postby Moderator » Thu Mar 24, 2011 8:33 pm

Rob, would you send a test package and tables DDL schema to support at pgoledb dot com? What is the number of rows in the table?

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 279
Joined: Wed Oct 29, 2008 11:27 pm

Re: Lost rows?

Postby rvallee » Fri Mar 25, 2011 4:01 am

Thanks for the reply. There are 152,000 rows total. I will see what I can put together. Thanks again.
rvallee
 
Posts: 4
Joined: Tue Mar 15, 2011 8:05 am


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

Who is online

Users browsing this forum: No registered users and 3 guests