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.

Then you should forget the Transfer SQL Server Objects task. Look instead at the Data Flow task where (at its simplest) you define a source, a destination and a mapping...

Really - OK, use a Script Task.

Here's some code:

Public Sub Main()

'

' Add your code here

'

...

Is your requirement to move data or to move schema info (or both)?

Why not just use a straight UNC path?