Create a Dataflow. In the Dataflow pane, create source and destination components and link them. Create a mapping from source to destination and then you can run the package.

Why not use a single Foreach loop to do the entire load/archive process?

This seems to delete files, not folders ...

Please post the code fragment which is causing the error and the text of the error message.

I was obviously in a 'read English, not code' mood when I responded, because I didn't even look at your DDL. Now that I have, I see that we were...

Thanks for the feedback, glad to have helped.

--deleted

Expanding on this idea,...

I just tried it and it worked as I suggested.

Against the properties for your flat file source, have you got 'retain nulls' set to true?

Something else is happening here.

If I import the record

Affinity,,CT

into a database, I can guarantee that field number 2 would not somehow become a space in my database table. Do you...

Sounds like a good solution to me.

dndaughtery (2/4/2010)

---

Yeah its in a script transform in a data flow component. I basically need a way to add a unique record id for each record. I'm open to any...

You use the word 'retain' in your original post. If a value is null in a database column and you export it to a text file, the way of retaining...

,, in a text file is the equivalent of NULL in a database table.

PATINDEX is not a valid function in SSIS expressions.

Maybe adding an additional condition would help:

&& FINDSTRING(Email,"@",1) < (LEN(Email)) - FINDSTRING(REVERSE(Email),".",1))