Let me give a brief description of my error. The scenario in ur post explained the package error when deployed from SQL Server agent. My scenario is that
The package configurations are from SQL Server.(Both SSIS and the SourceDatabase).
When i run the package for the first time after creating it in BIDS, it runs successfuly.
When i close the package and reopen it for the second time in BIDS, i get the package loading error as mentioned in the previous post. My doubts are .......
1. Can we have both the SSIS and the source database connection strings in to the same table (SSIS Configurations) in SQL Server?
2. Does the package protection level has impact on SQL Server connection strings....?
3. Should i want to change connection managers?