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.

Please explain what you mean by "manually executed through SQL Server"

I guess you mean as part of a job. Are you logged in to SQL Server as the same user...

da-zero (5/5/2010)

---

To give a little more explanation:

DTS is the old version of SSIS. DTS uses .dts files, SSIS uses .DTSX files.

You can compare it with .xls for Excel 2003 and...

You cannot open dtsx files in DTS.

Maybe this will help:

http://msdn.microsoft.com/en-us/library/dkkx7f79%28v=VS.71%29.aspx