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

3 votes336 views1 answer
Initialise icollection c#
C#
0 vote277 views1 answer
C# use cefcharp and selenium can?
C#
32 votes320 views4 answers
How to get keyboard input in unity
C#
0 vote410 views1 answer
CRUD configuration MVC with Firebase
C#
36 votes359 views5 answers
Unity key pressed
C#
120 votes580 views6 answers
C# math random
C#
1 vote411 views1 answer
Unity time.deltatime timescale 0
C#
0 vote335 views2 answers
Replace multiple characters in string c#
C#
0 vote336 views1 answer
C# create list with range
C#
3 votes326 views1 answer
Remove all text after string c#
C#