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 vote260 views2 answers
Asp.net core get root url in view
C#
1 vote286 views1 answer
When do i need to end a sentence with ; in c#
C#
2 votes276 views2 answers
How to split concat string c#
C#
0 vote278 views1 answer
Unity restore deleted files
C#
0 vote267 views1 answer
Font dialog c# code
C#
0 vote265 views2 answers
Timespan format string c#
C#
0 vote273 views1 answer
OIUJHKJHSKAL::KSAJ
C#
3 votes326 views2 answers
Unity instantiate empty gameobject
C#Unity
2 votes338 views1 answer
Camera follow player unity smooth
C#Unity
4 votes307 views1 answer
Unity cast int to float
C#Unity