I think that the 80004005 error is File Not Found.... Check that the Windows user that the SQL Server Agent uses has permissions on that file/folder.

Matt,

In the Package Properties of DTS2, go to the Logging Tab and in the Error Handling section click on Fail Package on First Error. Save that change.

You can then have...

Because inf and outf will be an object (file) itself you need to use SET. Try:

Set inf = fso.opentextfile(fx,ForReading)

Set outf = .....

I don't think that I'm understanding this...

Surely the pKey INT IDENTITY(1,1) column gives the "uniqueness" that you need?

Can you post the SQL code for the ExecuteSqlTask that is failing?

Now this hasn't been fully tested ( and thanks to MIT for an accessible CSV file on the net!). The Stored Procedure below retrieves a CSV from the web and...

To be totally honest, I don't know.

There's a very brief article about upgrading here: http://support.microsoft.com/kb/281574/

Sorry I can't be of more use.

You'll need to be careful with this as some procs take up more than one row. The code below is almost and over-simplified solution to your problem. If your procedures...

The error seems familiar in the fog at the back of my mind.

It could be a permissions issue. You can download a handy tool...

If you only have the one Sql Server then your installation is not clustered. You should be able to upgrade as instructed.

When you run a DTS package from your machine using Enterprise Mangler the DTS uses local resources to execute the tasks. Check your dependencies, connections and configuration for the Sql...

Hi,

I'm wondering if it's to do with the SELECT @date = @date + 1 line not functioning as required. If you change it to DATEADD(dd, 1, @date) and try that(?!?)...

Importing directly from the Response object would depend on the file format. If you could tell us this, we might be able to move this on a bit further...

I don't have a document on DTS Internals, however, if you can post the task and error details we might be able to help you with your troubleshooting.

Something like:

 Dim objSvrHTTP

 Dim fso

 Dim f

 Set objSvrHTTP = CreateObject("Msxml2.ServerXMLHTTP.4.0")

 objSvrHTTP.open "GET", "http://www.example.com/filename.txt", false

 objSvrHTTP.send

 Set fso = CreateObject("Scripting.FileSystemObject")

 Set f = fso.createtextfile("c:\mylocalfile.txt")

 f.Write objSvrHTTP.responseText

 Set f = Nothing

 Set fso = Nothing

 Set objSvrHTTP = Nothing

...in...