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...

I'm sorry but I don't have the time to write all of that stuff out right now.

But - regarding the Resultset property - this is a property of your Execute...

It seems to me that you don't really know what is going wrong here - just 'something'.

If you hard code the parameter values, does the query work OK? Are you...

I'm afraid you threw me off the track when you called it a global variable.

VariableDispenser gives you access to package- or task-scoped variables - not locally declared variables within your...

Something like this, maybe:

Dim f As String

For Each f In System.IO.Directory.GetFiles(path)

System.IO.File.Delete(f)

Next f

Sounds like your row delimiter may be set up incorrectly.

What appears at the end of every row of your source data?

You can assign values to variables within a Script Component if you use the VariableDispenser class.

See more here.