thank you very much. how simple. I couldn't see the forest for the trees!

Samuel, that works so awesomely. I appreciate.

Recently I had to put a foreach loop around each DFT for which I wanted to dynamically supply the flat file connection name...

without them.

Samuel, The message box line of code works.

When I execute I get

'the rowcount for settings_campaign.txt* is 0'

I am feeding the filename to the script via the User::FilterValue ...

OK, hi nevyn, jeff, martin.

Answers:

There are 14 files daily which translates to 14 tables. I will give numbers for the three biggest tables (settings_dimension/keyword/group).

How many rows are...

Hi Nevyn, yes I'm doing one big merge statement from stage to final table. So, you are saying there is better approach. Will you please say more about rhe merge...

Hi Nevyn, In the early design phase of etl solution and I simply cut hours off the etl when I removed indexes. This allowed me to take a look...

OK, it appears that despite the intellisense feedback it is building successfully. To be sure I'd like to see the output pushed out to a message box.

Samuel......

Can you give...

. I have multiple versions of visual studio installed....2008 and 2010. I wonder if this means I Ihave multiple ssis installed. Will check it out.

Hi Sam, script task parses with your script and even turns green. how to check the value returned?

Also, not completely sure it's ok because inside Edit Script there...

ZZ, please clarify 'performance' impact.

OK, will do.

But I think the only 'gain' here is that it prevents insertion of data that is way out of scope of what is expected. No other reasons...

Functions aside. This is not a question asked in the context of functions to which I might want to pass parameters which need to specify datatype and length.

I am...

yes, there are many posts that say it doesn't matter which I why I asked here.

But if that is the case, why is there an option to specify length for...

removed 'powershell' from the beginning of the argument was solution