I am getting the following error when my DTS package is scheduled:
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
I am not sure how to get my DTS packages to execute. They run fine when I manually execute them
I am running SQL Server 2005. DTS Packages were created using the Import/Export Wizard.
I changed authentication from SQL Server to Windows Auth and it did the trick. Not sure the technical reason why.