I have a text file around 45,000 records I'm trying to Import. Its a CSV
file and appears to die after 15,000 or so records Imported due to
non-whitespace characters in a row. Is there any script or transformation I
can do to cleanup the file.

Sql7SP4



Thanks.

Not exactly. You would have to write up a custom activex script task using the file system object. Should be pretty simple..

----- HartmanA wrote: ----


I have a text file around 45,000 records I'm trying to Import. Its a CS
file and appears to die after 15,000 or so records Imported due t
non-whitespace characters in a row. Is there any script or transformation
can do to cleanup the file

Sql7SP



Thanks