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?

You could try setting the initial value of the string variable to be a valid package name (ie, in Package / Variables).

Try setting the DelayValidation property of the Execute Package task to True.

It does its best, but yes.

Can you summarise what you need to do? Maybe there are faster alternatives which you have not considered.

No apology needed - you were very polite and not at all rude.