I have 4 packages which runs without any issues if i run these packages individually. All the package sources are flat file and the destination is SQL server table. In my scenario i have created another package which have 1 sequence container within that i have included 4 execute package task and i have called that 4 packges. Everytime opening the sequence container packge i am getting connection issue. once edited connection than i can able to run. how can resolve this issue? Thanks in advance. Thiru-BI

what error you are getting ??Shailesh , Please mark the post as answered if it answers your question.

connection ID not found which is available in alpha numeric formet.

is this the complete error message can you please post complete error message ?? how you are configuring execute package task using file system or sql server just try to execute container after disabling all execute package task to check whether you are getting error due to execute package task or due to parent package connection issue. because while Googling i got link which saying that error is due to connection is missing connection in Logging see this http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2af470ac-d76d-4162-849f-a5e0411aa053/ http://texhex.blogspot.com/2007/10/ssis-error-while-loading-package.html hope this helps!!Shailesh , Please mark the post as answered if it answers your question.

is this the complete error message can you please post complete error message ?? how you are configuring execute package task using file system or sql server just try to execute container after disabling all execute package task to check whether you are getting error due to execute package task or due to parent package connection issue. because while Googling i got link which saying that error is due to connection is missing connection in Logging see this http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2af470ac-d76d-4162-849f-a5e0411aa053/ http://texhex.blogspot.com/2007/10/ssis-error-while-loading-package.html hope this helps!! Shailesh , Please mark the post as answered if it answers your question. Hi Thiru – BI, 1) Have you copy pasted the Execute package task from other package in this new package of sequence container? 2) The problem might occur due to this copy paste. 3) Try creating the Execute package tasks freshly and call the child packages. Hope this helps ! Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!