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 |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2002-10-07 : 11:37:10
|
| I created a dts package that i execute from a job.my goal is to:1. create a dts package to import 4 text files into 4 staging tables2. create a job a step1 delete old data from 4 staging areas delete from center_stage delete from lfcch_stage delete from lic_exempt_stage delete from sfcch_stage b step2 execute dts package and bring new data into staging areas DTSRun /S sql2000 /U sa /N NLS c step3 interogate data and insert it into provider table.The reason i place the data into 4 staging tables is to keep a copy of it before moving it into the provider table.My problems is that i get the following message:WARNING : The following job step(s)cannot be reached with the current flow logic:[2] step 2Note: The On Success action of the last Step will be changed from 'Goto Next Step' to 'Quit with Success'.Are you sure this is what you want?I went back in and change the first step to step1 Goto Next Stepstep2 Quit with successIt works but why does it give me that error message??Should i worry about that? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-10-07 : 11:50:38
|
| Sounds like you created the job to start at step 1 with step 1 quitting on success and step 3 going to next step on success.Changing it tostep 1 goto next stepstep 2 goto next stepstep 3 quitall on success is what you probably want.==========================================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. |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-10-07 : 14:34:57
|
| You should strongly consider truncating those four staging tables instead of deleting from them to avoid unnecessary transaction logging.Jonathan{0} |
|
|
|
|
|
|
question about executing dts pack from job?