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 vote272 views1 answer
C# LCP
C#
0 vote311 views1 answer
How to have referecne to script in unity
C#
0 vote284 views1 answer
C# create list with range
C#
1 vote295 views1 answer
How to set the frame rate unity
C#
3 votes264 views2 answers
C# bytes to image
C#
0 vote271 views1 answer
C# writeline list
C#
7 votes274 views2 answers
How to make a character move in unity 3d
C#
0 vote304 views1 answer
Hide numericUpDown arrows
C#
0 vote332 views1 answer
Cannot convert string to long c#
C#
0 vote300 views2 answers
C# servercertificatevalidationcallback
C#