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.
| Author |
Topic |
|
Amethystium
Aged Yak Warrior
701 Posts |
 Posted - 2003-12-04 : 10:04:31
|
| Hello guys...I have a DTS package that is made up of around 30-40 separate SQL Tasks. I have the scripts connected via a 'On Success' workflow property but for some reason one of the tasks which inserts some data in to a table doesn't actually execute when I run the package. However when I go in to the package and right-click on the SQL Task and execute, the table in question is populated. I am 100% sure that I am not missing anything in the package and I am also sure that I am running the latest version because I've actually removed all the previous ones.Any ideas?________________Make love not war! |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2003-12-04 : 11:17:55
|
| Right click on your "on success" green bar then "properties" to verify if your task will execute after the success of the previous. Sometimes depeding on the order that the task are created, some do not execute, or do not execute at the right time.If your task is not there, use the "new" button to add it. |
 |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2003-12-04 : 11:29:07
|
| Yes I forgot to mention that I also checked the same property you mentioned in your reply but the problem still occurs.________________Make love not war! |
|
|
|
|
|
|
DTS package acting weird