Ssis sql query in script task

ConnectionManager cm;
System.Data.SqlClient.SqlConnection sqlConn;
System.Data.SqlClient.SqlCommand sqlComm;

cm = Dts.Connections["conectionManager1"];

sqlConn = (System.Data.SqlClient.SqlConnection)cm.AcquireConnection(Dts.Transaction);
sqlComm = new System.Data.SqlClient.SqlCommand("your SQL Command", sqlConn);
sqlComm.ExecuteNonQuery();

cm.ReleaseConnection(sqlConn);

Source: stackoverflow.com

Similar codes

2 votes179 views1 answer
Draw sphere gizmo unity
C#
0 vote187 views1 answer
Wpf app how to get all elements which are exposed to script
C#
0 vote189 views1 answer
Office open xml check if row is empty
C#
1 vote185 views1 answer
Dapper delete where in list
C#
0 vote216 views1 answer
How to make play button in unity
C#
10 votes194 views1 answer
Get value after decimal point
C#
1 vote174 views2 answers
Delegates in UnityC#
C#
1 vote224 views1 answer
Csharp check if env is development
C#
0 vote209 views1 answer
C# windows application get current path
C#
13 votes420 views2 answers
How to make an object move in unity
C#Unity