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 |
|
PaulTeal
Yak Posting Veteran
67 Posts |
 Posted - 2003-09-19 : 10:57:25
|
| I have a nightly DTS package that has me puzzled: Step 1 is a data pump importing data. On success Step 2 is an execute SQL task that executes a stored procedure that adds rows to another table based on information from the import. On success Step 3 is an execute SQL task that executes a stored procedure that alters some of data.Steps 1-3 run every night with no errors, but if I look at the data, Step 2 never ran.I can make a package that runs step 2 that will work. I can open the package in design mode and execute the step. I can run the procedure in Query Analyzer. I cannot get the stored procedure to raise an error, yet for some reason the package skips step 2.I cannot change the order or split the package up, so I have to figure out what the problem is?Do you have any ideas of some things I can check?Paul Tealpaul@partytilyoupop.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-19 : 12:05:58
|
| Log the execution and see what is happenning.Probably the step is executing but not inserting any data.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-19 : 12:16:09
|
| I have had to recreate packages from scratch sometimes because it just stopped working with not a single change made. I am sure it is a bug somewhere. I tried just recreating the job schedule, but that didn't work, so I had to recreate the DTS package. I have actually had to do this about 3 times now. On the servers where this occurs, we are only on service pack 2. We'll be on service pack 3a in about a month though, so hopefully 3a fixes it.Tara |
|
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2003-09-19 : 15:05:26
|
| 'Log the execution and see what is happenning.'I'm not sure what you mean. Is this different from viewing the history?Paul Tealpaul@partytilyoupop.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-19 : 15:08:57
|
| If you go to the properties of your package, you can turn logging on. Open your DTS package, go to package, then to properties. You'll see the logging tab from there.Tara |
|
|
|
|
|
|
DTS Conundrum