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 votes205 views2 answers
How to freeze x and y position in rb2d with code unity
C#Unity
41 votes194 views6 answers
Samsung sam
C#
1 vote146 views1 answer
Bold caption latex
C#
11 votes141 views2 answers
C# array.join
C#
0 vote167 views1 answer
Listview inter thread operation not valid
C#
4 votes152 views1 answer
What value of combobox index c#
C#
0 vote170 views1 answer
How to disable device guard or credential guard vmware
C#
0 vote154 views1 answer
Disable alt + f4 in c# forms
C#
0 vote146 views3 answers
Regex check is valid ip
C#
0 vote153 views1 answer
Get path revit link unloaded
C#