I have an xml configuration file for my package which has the DB connection and smtp connection. The path to the config file is stored in an environment variable. I also created a package configuration variable with configuration type 'Indirect XML Configuration File' pointing to my environment variable. I deleted the db connection manager that I was using earlier for OLE DB connection in my execute sql task. Now my execute sql task in the package is broken because it cannot find the DB connection. How do I make it find the DB connection from the configuration file? Error 1 Error loading Document_Mgmt_Inbound_Process - V3.dtsx: The connection "{CE0FE0CC-BD3B-4151-8A61-7678BD80EEB7}" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Users\myuser\Documents\Visual Studio 2008\Projects\Integration Services Project\Integration Services Project\Data_Mgmt_Process - V3.dtsx 1 1 Thank you.

I think you neglected to export its properties to the config file. See this post on how to set the configuration properly up: http://www.sql-server-performance.com/2007/package-configuration-2005/Arthur My Blog

why you deleted the connection manager ?? thats why you are getting error The connection "{CE0FE0CC-BD3B-4151-8A61-7678BD80EEB7}" is not found. paackage configuration will only give the property values at run time to connection manager what you configured while creating package configuration like connection string etc see this link to understand http://msdn.microsoft.com/en-us/library/cc895212.aspx http://www.mssqltips.com/tip.asp?tip=1405 create the connection manager with same name and try to run package Shailesh , Please mark the post as answered if it answers your question.