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 vote366 views1 answer
C# convert excel column index to letter
C#
0 vote358 views1 answer
Enable canvas unity
C#
1 vote343 views1 answer
Stop displaying button in android
C#
0 vote338 views1 answer
StackTrace getframe last frame
C#
0 vote336 views1 answer
C# How to display text in console
C#
0 vote359 views1 answer
DefaultContractResolver .net exclude null values JsonSerializerSettings ContractResolver DefaultContractResolver
C#
0 vote369 views1 answer
Could not load file or assembly 'Ubiety.Dns.Core, Version=2.2.1.0
C#
1 vote348 views1 answer
Connection string in asp.net with username and password
C#
0 vote350 views1 answer
C# odp.net close session
C#
0 vote353 views1 answer
C# How to read users input and display it
C#