I think you'll have to use command line in the scheduler and point to the x86 DTExec.

Here's a sample I found in another discussion group:

C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /f...

Not sure if this will help or not, but you might try going into the actual package properties and under the Security make sure the ProtectionLevel is set to Don'tSaveSensitive....

I think you'll have to check properties of each task in your package. One of the tasks is still referring to the old connection. Wherever you see that guid show...

You can define an Excel connection manager in your package. Point it to an existing spreadsheet. Go into the Excel Connection manager properties. Then into expressions. Find the ConnectionString property and open the expression box for...

I'm not sure it this is what you're looking for. If you run the package from within Visual Studio you can go to the Data Flow tab and the rows...

There are some free e-learning courses at this site. Hope this helps.

http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx

MarkA

I did this pretty quickly so I'm not sure if it's exactly what you're looking for. You can plug variables into the where clauses to make it a little more...

Here's another good link on dts:

http://www.sqldts.com/