Use an Aggregate transform. T-SQL is faster though.

That's quite unpleasant.

You will need to read in the source data as a single string (no column delimiter) and then use a Script Component to parse & reformat the data...

Please post this in the BI forum - this is not SSIS related, as far as I can see.

"...spaces in the flat file itself..." I do not understand exactly what you mean. You did not answer my question about 'End of Shift'. Please provide accurate sample data.

What is the data type of the destination column?

Can you be a bit clearer with your example? Are you saying that

'End of shift'

is being saved as

'End of shift...

I think you need to be posting this question in the BI forum, here. This forum is for SSIS-related items.

If you are loading a static text file, you already know its name - so you're not doing that, I'm guessing.

If you are loading multiple dynamically named text files, I'm...

Might be easiest to output to a single folder and then run a simple piece of script to do the move.

No problem. Have fun learning and post back with any specific problems you have along the way.

Does the variable have a valid 'default' value (as viewed under SSIS/Variables/Value)? Maybe this is being used.

Here it is in outline - the detail will take quite a bit of working out as you are new though:

A Foreach loop can read through all of the files...

Elliott W (5/10/2010)

---

If I understand your requirement you want to run a process against 20 seperate database files. It is the same process for each and the only thing...

Is your domain really called 'domain'?

By the look of your code, if you really want to convert properly to SSIS, you can throw all of this code in the bin (metaphorically, of course) and use...

OK, can you post your expression then?