hi, we are using c# program to create SSIS package dynamically. Once package is created it will saved physically (C:\) and executed. After executed if i run count(dbid) from sys.sysprocesses, it gives list of open connections with sleeping status. Why it's NOT getting closed? Should i set any properties in SSIS package? Because of this multiple 1000s of connections are created and could not able to run the application. Please help me out.

Hi, You need to handle this from C# Code itself, Just close the connection once you create the package successfully. like con.close()Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.

Thank you Rajesh. We are closing all the connection from c#. We have used finally block and closing properly. however connection are remaining on SQL server. So, would like to know do we have any seetings in SSIS in which we can close the connection.

The below query gives more than 2000 slepping connections after running our applications for 1 hr. Our application internally creates SSIS packages and executes. SELECT COUNT(dbid) as TotalConnections FROM sys.sysprocesses WHERE dbid > 0 we are using using (SqlConnection connection = new SqlConnection()) to open Connection. Please let me know if you have faced similar issues.