Home > SSIS Best Practices > Execute SQL Task – Favorite in SSIS

Execute SQL Task – Favorite in SSIS

Execute SQL Task is is my favorite in SSIS. We can use this to run a single or multiple SQL statement at a time. It can return results in different ways e.g. single row, full result set and XML. You can create different type of connection using this component like OLEDB, ODBC, ADO, ADO.NET and SQL Mobile type etc. It can be used with the FOR Each Loop container to define iteration loop on the basis of result returned by Execute SQL Task.

For more information, please see http://msdn2.microsoft.com/en-us/library/ms141003.aspx

Categories: SSIS Best Practices
  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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

%d bloggers like this: