Post reply

Integration Services Package Store Objects

  • July 27, 2009 at 6:18 pm

    #132329

    I have deployed a *.dtsx file to the Integration Services package store.

    When I execute the object it runs successfully.

    However, none of the tasks within the object are executed.

  • July 28, 2009 at 6:13 am

    #1030974

    Hi

    I know this sounds stupid, but have you re-downloaded the package and opened it in VS? More times than I care to remember have I opened a package to find that the contents have just magically dissapeared. It seems to coincide with copy and paste edits.

    Just a thought.

  • July 29, 2009 at 6:31 pm

    #1032097

    thanks for the response, i had multiple tasks in the package and had disabled the first half of the tasks to test the second half of tasks. Anyway, i left the success connection in place which connects the disabled tasks to the enabled ones. So, the package store was reading disabled objects and just dying.

  • July 30, 2009 at 4:48 am

    #1032273

    Hello,

    Did you deploy all the dependent objects (if using Execute Package Task *.dtsx) along with the Parent Object on SSIS Package Store.

    If so then it wouldn't fail. Else let me know.

    Thanks

    Chandu

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

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