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

Are you executing these packages manually?  If so, has the account you've logged on to your network been granted access to the database on the new server?