Home > SSIS > Execute T-SQL Statement Task – SSIS 2012

Execute T-SQL Statement Task – SSIS 2012


Execute T-SQL Statement Task in SSIS 2012 helps us to write and execute TSQL statements inside the SSIS package instead creating it in database. It save a lot of developer’s time and help to manage code in one place.

Execute T-SQL Statement Task component

Implementation

Step 1: create a package and add Execute T-SQL Statement Task.

Step 2: Edit the task and create new database connection and add T-SQL statement in the text box as shown in the image.

Step 3: Execute package now.

Thanks for reading.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: