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.

Oooh, so you did - I...

This is an SSIS forum, so you won't be surprised that that is what I would recommend 🙂

DTS is the SQL Server 2000 version of SSIS and is therefore old...

Please be more specific about what you mean by 'integrate'.

Can the SQL Server data be updated by anything else?

Is there are date/time last updated field on the Oracle tables?

Well done for getting there in the end and thanks for posting your solution - glad to help.

I would suggest that you look at the source file in a hex editor and compare what you see with another file which works. There will be a difference, I...