Unanswered: How do you validate and scrub using DTS?
When I use the DTS GUI and insert a "Bulk Insert Task" the main tab says:
"Import text files into SQL Server. You cannot validate, scrub, or transform data using this task".
So my question is, what shoud you use to validate and scrub?
In particular I have fixed-format text file with some occasional bad records (e.g. wrong length, empty record). What should I be using? If you suggest vbscript could you show me some examples? I'm new to vbscript.
Does a little challenge scare you away? Check MSDN, BOL, Technet, Google if nothing else. See if you can find something on accessing text files using a scripting language (any.) OK, a hint, - FileSystemObject, look for it.