I think you might be able to take what's in this article and modify it to suit your needs:

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

Do you have the proper permissions to execute xp_cmdshell?

I added this line to an Execute SQL task and it worked:

EXEC master.dbo.xp_cmdshell 'START c:\test.bat'

Make sure the last command in your batch...

Can you reach these FTP sites and see files with your web browser, a command prompt, or some FTP software like Filezilla?  If not, the problem isn't with the http://FTP...

Set the global variable = Nothing at the end of your Active X Script task.

DTSGlobalVariables("Name of var").Value = Nothing

You'll be able to save the package.

Execute a CREATE TABLE statement to create a "permanent" version of your temp table, insert records into it, then execute a DROP TABLE statement when you're done.

Yes, there are a few ways to do this.

One way would be to add an Active X script task after your import task that uses the FileSystemObject to delete the...

You'll never guess the answer.

Excel_Application.ActiveSheet.Unprotect "enter password"

Add the following line just before "Excel_WorkBook.Save"

Excel_Application.ActiveSheet.Protect "enter password"

No, it will not.

Not sure what's going on, but one way to get some more information would be to go to the Options tab of your data transformation's properties, entering a path for...

This is the "Security Accounts Manager" service.  Look at the services on your computer and verify that you see the service in the list.  If it's disabled, try to restart...

I don't think you can hide the command window while using osql.  You can hide it if you use WScript.Shell in an Active x script task.

When a DTS package is scheduled as part of a SQL job, it runs under the same account that runs the SQL Server Agent unless you specifically set the username...

Open up your DTS package and select the Properties/Disconnected Edit menu.

In the window that appears, expand the "Steps" section.  Select one of the steps in your package.  Double-click on the...

I don't know about SSIS, but in DTS you could store the results of your query in Global Variables, then use an Active x script task to open the .xls...