Home Forums Data Warehousing Integration Services Records not updated RE: Records not updated

  • April 16, 2014 at 8:36 am

    #1706495

    dwilliscp (4/16/2014)

    I have a lookup records that feeds into a OLE DB Command. When I execute everything turns green and the lookup match output gives 847 rows.

    But looking at the debug it never states that the componet "Update Records" was run and it never states that rows were updated. (also the data does not change)

    So what could be wrong?

    Are you calling a stored procedure or an update statement with try/catch? That could suppress the error so it never reaches the package.

    😎