Home > SSIS, Technical > SSIS – SQL task and Script Component

SSIS – SQL task and Script Component

This below link explains in detail about creating a SSIS package in VS 2008, project folder structure and designer.  Good for a beginner.

Tasks in the Control flow toolbox:

The Execute SQL Task:
This task is widely used in the packages.


A word of caution is below:
“MSDN recognize as a SSIS bug that a bigint output parameter returned by a sql stored procedure cannot be assigned to a Long SSIS variable .”

Webservice task:
The below link has a document explaining the usage of webservice task in a clear manner.

Here are some useful tools in the Data flow.

Data viewer:

Data Viewer is truly a unique feature, which provides the ability to view rows of data as Integration Services processes them in the data-flow pipeline.

Script component:

SSIS has script components both for control flow as well as for data flow. These allow users to write scripts in Visual Basic .NET. SQL Server 2008 includes Visual Studio Tools for Applications, which provides a scripting environment in which you can use Visual Basic .NET, or C# to implement script components. In SQL server 2005, the only choice is VB.

  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 )


Connecting to %s

%d bloggers like this: