Hi, i have a considerable number of SSIS packages that pull data from different data sources, Since there are multiple environments for the SQL server boxes i have used Package Configuration option with environment variables. Everything works ok, except for errors thrown as given below, I have an entry in the configuration DB for each Data Source, but a Package will be using only those connections which are relavant for it, for all entries in the configuration db which doesnt have an associated connection in the SSIS package it throws the below error Error: The connection "CN8control" is not found. This error is thrown by Connections collection when the specific connection element is not found. This doesnt stop the execution of my package, but in cases where i am calling the package from a parent package it fails because of the MaxErrorCount = 1 setting Is there anyway we could set the error reporting off for packages which doesnt use the datasources thanks, Rakesh

if you have connection strings in the package configuration, you can create dump connection managers with same name as exists in package configuration to get rid of those errorshttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

check this http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8415a698-7a93-4de3-b1d5-98e4e1849aac/Shailesh , Please mark the post as answered if it answers your question.