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

0 vote123 views1 answer
Return an interface or a class C#
C#
1 vote152 views1 answer
Unity text display int
C#Unity
0 vote125 views2 answers
How can i replace Any for All method and vice versa linq in c#
C#
0 vote119 views1 answer
How to input parameters in c#
C#
0 vote119 views1 answer
C# azure get vm get cpu usage
C#
0 vote131 views1 answer
C# url relative path remove
C#
0 vote127 views1 answer
C# quick "is" "as"
C#
0 vote127 views1 answer
Access form in a folder C#
C#
0 vote129 views1 answer
Untiy particle system play
C#
1 vote129 views1 answer
How to make an object jump in unity
C#