Lost rows?

[rvallee]

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

[Moderator]

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!

[rvallee]

Thanks for the reply. There are 152,000 rows total. I will see what I can put together. Thanks again.