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

-1 vote112 views1 answer
Run as administrator vs 2019
C#
0 vote181 views2 answers
Blazor onchange event not firing with inputselect
C#
2 votes163 views1 answer
C# skip following code in loop
C#
0 vote184 views1 answer
How to check if the value is alphabet and numbers only only in c#
C#
0 vote159 views1 answer
Nethereum check gas price
C#
0 vote173 views1 answer
Timespan to integer c#
C#
0 vote171 views1 answer
How to get mouse position c#
C#
0 vote240 views1 answer
How to set picturebox width with form width in c#
C#
0 vote174 views1 answer
UnitType parameter revit 2022
C#
0 vote186 views1 answer
C# linq distinct group by nested list
C#