Or another option, if you have the package already set to EncyrptSensitivewithPassword, in management studio, set up a job that will call your dispatcher. Then go to the Command line...

Try this then, use the package configuration file. Save the user name and password into the configuration file. Then change the package setting to DontSaveSensitive. Then try to run it...

Right click on your FTP connection manager, go to its Properties (the very bottom, not the Edit button), and type in the password.

save your package with EncryptSensitiveWithPassword.

That's how I made...

Anyone knows of a good training class for Microsoft Analysis 2005? I'm located in the San Francisco bayarea, anywhere close to here would be good, but open to other locations...

You have to create a credential and a proxy account for SSIS Package Execution (underneath SQL Server Agent, Proxies, SSIS Package Execution. Before you set up a proxy account you...

I'm having the same problems..I'm using DBCC INDEXDEFRAG, not even using DBCC DBREINDEX.

Which command are you using?