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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-25 : 22:10:31
|
| PeterH writes "I have created a DTS package to load data from an Excel spreadsheet into a SQL7 database (SP1). There are 3 worksheets which are loaded into 3 separate tables.I have tried to cater for errors in the process such that if any of the 3 steps fail then all the data is removed. I have created On Success and On Fail precedents to either continue the loading or execute a script to remove the data loaded so far.If the first step fails (which is loading a single record into a table), the package stops at the appropriate point having executed the On Fail step. However if the second or third steps fail (these are loading multiple records) then the package continues as though the step was successful. The 'Progress Monitor' which shows the steps as they are being executed shows the step with an error in red, but then continues down the On Success route.Any ideas?" |
|
|
|
|
|
DTS Problems