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 vote137 views1 answer
If in dictionary c#
C#
16 votes120 views2 answers
Movetowards unity
C#Unity
1 vote142 views1 answer
Unity how to ommit letters from a string
C#
0 vote132 views1 answer
Linq while loop in c#
C#
20 votes142 views1 answer
How to write switch statement unity
C#
0 vote126 views1 answer
Mvc session key exists
C#
-2 votes136 views1 answer
C# exceptions list
C#
0 vote135 views1 answer
Come controllare se textbox è vuota c#
C#
0 vote154 views2 answers
Wpf datagrid get selected items
C#
1 vote139 views1 answer
How can you learn C# on your own
C#