Post reply

SSIS Package won't execute - claims it's done.

  • July 21, 2009 at 10:38 am

    #1027788

    I am getting the same thing, what I noticed is the post execute gets to 25% and the package ends with a status of canceled.

    The data flow ran meaning the data was read, transformed, and written successfully and all data flow components are green but the data flow container is yellow and package is done.

    Now on this particular data flow I had an OnError event that would set the Propagate variable to false, that appears to be when the problem started. I deleted that event and the problem continued.

    I added a new data flow task, copied all data flow components to this new task and the data flow runs fine and the task completes.

    I can't find any differences between the two, all properties are the same (except the name) and there are no events for either task.

  • July 21, 2009 at 10:49 am

    #1027795

    thanks for the input.

    I stuck in a where clause that significantly limits the data from a few million rows to a few thousand and it runs just fine.

    As i mentioned before, this package has run successfully before so i don't understand the limit all of a sudden AND it works fine against the AS400 and not the DB2 database.

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

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