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 vote306 views1 answer
Good food
C#
0 vote288 views1 answer
Decrease image size C#
C#
9 votes370 views2 answers
Unity find gameobject with layer
C#Unity
2 votes289 views2 answers
HCF of number
C#
0 vote295 views1 answer
How to add onclick event dynamically in unity
C#
1 vote330 views1 answer
How To Copy a text C# unity
C#Unity
0 vote296 views1 answer
Unity control physics of multiple simulation
C#
0 vote295 views1 answer
C# print expression tree
C#
0 vote292 views1 answer
How to execute a function in every object of list c#
C#
2 votes289 views2 answers
How to play sound effect in unity fmod
C#Unity