Integration Services Package Store Objects

• angel_mata

  SSC Rookie

  Points: 29

  More actions

  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.

• NaffMonk

  Old Hand

  Points: 325

  More actions

  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.

• angel_mata

  SSC Rookie

  Points: 29

  More actions

  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.

• Sasidhar Chandu

  Mr or Mrs. 500

  Points: 506

  More actions

  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