I see this error occur when the Profile Name in the Send Mail Task properties does not exist on the SQL server.

Use the lcd command to specify where you want the files to be copied to on your network. UNC paths work.

Use the cd command to move to a...

There is a File Transfer Protocol task object you can use in a DTS package. I personally don't like it and create an Active X Script task that creates...

By description, I assume you mean a list of the column names. There are number of different ways you can do this.

One way would be to...

Does the DTS package always fail on the same transformation?

Are all of the source files on the same server?

Are they all imported into the same SQL server?

You could try using...

Can you still create SQL jobs in 2005?

If so, why not create a SQL job that will execute the package then use sp_start_job to run the job?

From the DTS designer, click the Package menu and select Properties, or right-click in a blank area of the designer and select Package Properties.

Go to the Logging tab on the...

If the files are in different formats, yes you'll have to create a separate transformation for each.

Are all of the files in the same format and will they be loaded into the same table?

If so, you could create 1 data transformation task then in an Active...

Follow these instructions:

http://www.dbazine.com/sql/sql-articles/larsen8

SELECT

CASE WHEN SecondAddress IS NULL THEN '' ELSE SecondAddress END

FROM

......

There are a couple of ways this could be done.   Here's one.  After your file has been created, add Active X script task that uses the FileSystem Object to write...

If you're trying to run the package from the DTS Design window in Enterprise Manager, then your personal permissions are used.

If this is executed via a job, the permissions of the...

Try this:

http://www.databasejournal.com/features/mssql/article.php/1458691

You don't have any tasks that are displaying a message box or automate MS Office functions, do you?