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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-10-05 : 12:47:26
|
| I have a DTS that imports from a text file into a table. I have set the "Max error count" under Options tab in the "Transform Data Task Properties" to 3. I also checked "Fail package on first error" under Logging tab in "DTS package properties". The question is that what happens if the 1st or 2nd or 3rd error occurs? Will the package fail? Or it won't fail until the 4th error occurs?Thanks,Canada DBA |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-05 : 13:14:24
|
| test it! |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-05 : 22:33:43
|
you can use workflow to control when tasks will be executed  --------------------keeping it simple... |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-10-06 : 12:43:13
|
Workflow? What's that? quote:
Originally posted by jen
you can use workflow to control when tasks will be executed --------------------keeping it simple...
Canada DBA |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-07 : 05:32:57
|
| question, did you design the dts package? you can see this at the menu bar of the dts designer,the workflow controls will provide you sequential execution of the tasks you have in the package--------------------keeping it simple... |
|
|
|
|
|
|
Fail package on first error