Should work as you hope. What is the scope of your variable? It should be 'Package'.

How do you envisage a user initiating this job? Is it their own spreadsheet or one held centrally?

I'm assuming that your question is not just: "Can SSIS import data from...

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'?