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.

What is the datatype of your derived column?

Yes. If there are hundreds of thousands of records to be deleted, I would recommend that you do the delete in batches to avoid huge transactions grinding your system to...

Where is your source data coming from? A DELETE query (or series of queries, if lots of rows are to be deleted) would be faster.