Lost rows?

  • rvallee
  • Topic Author
  • Visitor
  • Visitor
11 years 4 months ago #1064 by rvallee
Lost rows? was created by 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

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

More
11 years 4 months ago #1072 by Moderator
Replied by Moderator on topic Re: Lost rows?
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!

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

  • rvallee
  • Topic Author
  • Visitor
  • Visitor
11 years 4 months ago #1080 by rvallee
Replied by rvallee on topic Re: Lost rows?
Thanks for the reply. There are 152,000 rows total. I will see what I can put together. Thanks again.

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

Time to create page: 0.062 seconds
Powered by Kunena Forum