Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Pkg won't run with disabled tasks

Author  Topic 

Trudye
Posting Yak Master

169 Posts

Posted - 2009-04-15 : 17:47:07
This has happened to several programmers and myself. If we disable the first few tasks in the pkg and click the (green) Debug button the pkg goes thru and passes validation and ends. No error msgs no tasks turn yellow, bottom line none of the enabled task exec.

We can run each enabled task individually by right clicking each task and clicking ‘Exec Task’. We can run the pkg from the beginning with all tasks enabled with no problem.

Has anyone else experienced this

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2009-04-16 : 07:17:43
Put a breakpoint of the first enabled task and see if it stops/starts there.
Go to Top of Page
   

- Advertisement -