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 vote138 views1 answer
C# test if char is alpha
C#
2 votes139 views1 answer
C# implement ienumerable t
C#
0 vote137 views1 answer
Get datacontext of parent wpf
C#
0 vote144 views1 answer
.Net Core Bundling & minification : .net core The name 'Scripts' does not exist in the current context
C#
-1 vote133 views1 answer
Wpf hexagon
C#
7 votes136 views2 answers
Find character from string c# count
C#
0 vote156 views1 answer
Web API - Stream large file to client
C#
0 vote154 views1 answer
How to set the server url in dotnet core
C#
0 vote132 views3 answers
Logical operators in c#
C#
0 vote136 views4 answers
Hovercraft Physics in Unity
C#