The Dispatch type is valid.  It's used for storing recordsets.  To see the values stored in this variable, create an Active x Script task and loop through the recordset.

 Dim objRS

 Dim...

Just use the Err object.

Err.Number

Err.Description

Don't specify the file name in the FTP site address.

Sure, use an Execute SQL Task to execute an ALTER TABLE command.

Take a look at this:

http://forums.techarena.in/showpost.php?p=1166315&postcount=2

2 options.

1) Change the data type of the global variable from Int to Integer.

2) Replace your code with this:

intExpectedFileCount = CInt(DTSGlobalVariables("ExpectedFileCount"))

A quick search for MDAC on microsoft.com will get you this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Have you tried reinstalling the latest version of MDAC?

When, exactly, do you get this error?  Opening the package, running it, or trying to save it?

I just used an FTP task to download a .zip file without any problems.

Maybe the user id you login to the ftp site with doesn't have permission to access the...

Yes it is.  You don't need Access on the SQL server either.

If you right-clicked on the package to schedule it, the DTSRUN command in your job contains version information.  The DTSRUN command will start out as "DTSRun /~Z" with a bunch...

You don't need DTS for this if the data is already in a SQL table.

A simple answer is to execute an UPDATE statement in Query Analyzer:

UPDATE YourTable

SET YourFieldName = REPLACE(YourFieldName,...

Try deleting all instances of the existing SQL connection object  in your package and adding a new connection back.

I believe it uses port 21. 

I've had many problems with the FTP task which led me to use an Active X script task to execute shell commands to http://FTP. ...