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

Use the connection you defined in Connection Manager in the Script Task - that is the way to work.

I am assuming that you tried creating a new connection using Connection Manager?

What happened when you selected New Connection / ODBC? Were you not able to see your system DSN...

Are you using a 64-bit machine by any chance?