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 |
|
BenSwitzer
Yak Posting Veteran
72 Posts |
 Posted - 2004-12-16 : 14:24:01
|
| I am importing a text file into a temporary table in a DTS.I then take the information and imput it into the final table.Each record has a Cycle and paygrade field along with many others(123 total columns).I need to make sure that all records within the temporary table have a cycle and paygrade that exists within the master cycle table. If any of them don't, I need to stop execution of the DTS. I have about three of these types of checks before I can take the information to the final table. Im not sure how to do this.Thanks,Ben |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-12-17 : 04:04:42
|
| I think you either want a Data Driven Query or perhaps a dynamic properties task, then if there are values in your temporary table that aren't in cycle or paygrade you don't run the rest of the DTS i.e. it needs to cause some sort of failuresteveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
BenSwitzer
Yak Posting Veteran
72 Posts |
Posted - 2004-12-17 : 07:27:59
|
| Im not sure how to return a failed status. Thats what Im having problems with. |
|
|
|
|
|
|
Stopping DTS execution based on query results