[smacks self in head]

Now I remember why I didn't use BULK INSERT... non-standard row terminator. I'm still trying to figure out how to type ROWTERMINATOR = 'CR' (or 'LF', can't...

>If it's just simple text file import, do you even need DTS ?<

Step one is import. There's some validation and checking before the staging table's data gets inserted into the...

>Take at look "Looping, Importing and Archiving" with DTS at http://www.sqldts.com/246.aspx&lt;

It's the package I'm using as a template for the loop, but each file gets loaded into the same table....