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 |
|
ciaran
Starting Member
40 Posts |
 Posted - 2005-07-22 : 11:00:47
|
| Hi all, i have a complex DTS package that imports a large text file an splits it into 6 smaller text files before inserting it in 6 sql tables. On importing the text file i want to carry out complex sanity checks determining if a value is an integer string etc. would my best solution be to iterate over this using the record set and make such checks in the vb code. |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-07-25 : 03:10:28
|
| Personally I would create staging tables and manipulate the data in there using SQL, then as long as there are no errors, the rest of the DTS can be executed without intervention.steveAlright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer. |
 |
|
|
|
|
|
sanity checks in DTS packages