Csharp

Search

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);

Comment

PREVIOUS	NEXT

Code Example
Csharp :: Get replace normal text from word document in C#
Csharp :: c# for loops
Csharp :: c# new object
Csharp :: linq c# where condition
Csharp :: int if null put zero c#
Csharp :: c# catch two exceptions in one block
Csharp :: dotnet create web api
Csharp :: c# 2d arrays
Csharp :: how to set the server url in dotnet core
Csharp :: list view in unity
Csharp :: strong email validation regex c#
Csharp :: How to invoke an AWS Lambda function asynchronously
Csharp :: how to remove from list from index c#
Csharp :: lightbox
Csharp :: unity trygetcomponent
Csharp :: string vs string c#
Csharp :: jobject alternative in system.text.json
Csharp :: c# button click gets assigned the last value
Csharp :: hive survive
Csharp :: How to cache database tables to prevent many database queries in Asp.net C# mvc
Csharp :: C# multiple button click event to textbox
Csharp :: dapper extension
Csharp :: enzymes chemical factory
Csharp :: // Force WPF to render UI changes immediately with this magic line of code...
Csharp :: asp.net list size
Csharp :: datareader get field names
Csharp :: How to add a button to a column in the DataGridView
Csharp :: Get cell value with formatting openxml
Csharp :: Fix Array outside the bonus
Csharp :: == vs equals c#

Search

CSHARP

ssis sql query in script task

ADD CONTENT