1) Yes

2) Add a Derived Column transformation between your source and destination and assign these items to new columns which can then be used further along your dataflow to INSERT...

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.