It's reasons like this that I view Microsoft Certifications as absolutely worthless..

FYI.. to everyone involved, the correct answer here is to write a C# app, or use the bulk...

No Shit... did you seriously just copy my reply word for word???

DTS is for people who don't know SQL or basic OOP programming, plain and simple =)

Are you still seeking an answer to this question? if so send me an email and we can communicate more directly on this problem.

-Chris

Easy...

Create a Data Flow Task (DFT) at the Control Flow Level of your package.  Next, add a Flat File Connection Manager to your package by Right-Clicking in the Connection Manager are...

Are you using SSIS, as it is in SQL Server 2005?

If so let me know and I have plenty of tips