Resume DTS Package Once and Error is Encountered

[JayKusch]

Morning Folk ...

Have a DTS Package that reads a file and imports it into a table. I want to be able to continue the package until all the valid records are entered. Problem right now is that when a records blows up the package, thepackage fails. I want to be able to read the next record and continue the process. any ideas? i have the BOL up and going along w/ the recent book by Wrox on DTS and SQL2K but i just have yet to find the correct answer.

Thanks

 

[aalmeida]

Well would be nice to have more info on your DTS like the answer to somw questions like:
What are the DTS steeps?
What determine that the data is bad? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[RickCole]

If you are using Data Transformation in the job step go to properties and then the advanced tab. You can set a Max error Count to a higher value (default is 0). I seem to recall Use fast Load had to be cleared for this to work.

Rick.