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 |
|
leahsmart
Posting Yak Master
133 Posts |
 Posted - 2005-04-06 : 07:00:07
|
| I am currently making a DTS to import some data.I need to add some fields to store some IDs so I add a SQL Task to add them.. all ok.. once the data has been imported I want to remove the fields so I add another SQL Task to remove them... BUT if the DTS fails half way through the fields are left there. So when I run it again it errors on adding the fields as they exist. I have tried adding a flow so it fails it then removes them then goes back and adds them again BUT it just ignors me and just stops after removing them!Does anyone know a simple solution to this?ThanksLeah |
|
|
|
|
|
Temp Fields in DTS