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

33 votes118 views2 answers
C# array of strings
C#
13 votes122 views4 answers
C# how to sort a list
C#
2 votes112 views3 answers
Unity always rotating object
C#
2 votes129 views1 answer
C# string format sepperate every thousand
C#
0 vote120 views2 answers
Can a dictionary type use get set c#
C#
0 vote171 views1 answer
Httpclient jwt token c#
C#
0 vote148 views1 answer
EventSource Web API C#
C#
0 vote161 views1 answer
Unity dotween sequence
C#Unity
1 vote158 views1 answer
How to convert nullable datetime datarow to datetime in c#
C#
0 vote124 views1 answer
Get dwgexport setting reivit api
C#