You left out the square brackets around the field name ...

That will do...

Please provide sample input data, along with desired output data.

The general solution to this sort of problem is to import the entire row into a single big varchar field and then break it up into your required fields as...

Vernon Jimmerson-306463 (7/14/2010)

---

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is...

I'd leave it as int and add a char(4) derived column...

Yes - I...

This is looking like a challenge. Other than using a chunk of procedural code to read through the data line by line (in order) and add a 'Group Number' field,...

Please present your simple solution.

You'll have a problem with September if you use that code verbatim!

<= 9 works better 🙂

Ed Zann (7/12/2010)

---

Another option would be to use the Data Flow Script Component. With this component you could employ regular expressions to extract and transform the numeric data and...

There is a much simpler way: use the FOREACH container to loop round all files in a folder and (if required) its sub-folders.

Try NULL(DT_DATE)

You can't put a space in a date field.

This is an SSIS forum. I suggest that you raise this in the T-SQL forum here.