Post reply

OLEDB Destination control doing select *

  • September 26, 2008 at 4:24 pm

    #123754

    I have an OLEDB Destination control that is supposed to be inserting rows into a DB2 table.

    Problem is that as part of the Pre-Execute the control is doing a "Select *" from the destination table with no where clause.

    The DB2 DBA can see the account the SSIS package is using to performing this select.

    I never told it to do a select *.

    The destination table has over 50 million rows and the process chokes and dies.

    This is happening on a production box.

    I think this is some kind of metadata validation but I'm not sure.

    How do I prevent this select * from happening?

    Thanks,

  • September 29, 2008 at 8:46 am

    #878435

    bump

  • October 2, 2008 at 12:07 pm

    #880139

    IBM's DB2 OLEDB connector issues a Select * when using the OLEDB Destination, since I can't use the MS version for DB2 I had to use an OLEDB Command with an Insert.

    No problems after that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply