Archive

Posts Tagged ‘and script component.’

SSIS – SQL task and Script Component

October 12, 2011 Leave a comment

This below link explains in detail about creating a SSIS package in VS 2008, project folder structure and designer.  Good for a beginner.
http://www.techbubbles.com/sql-server/creating-a-ssis-package-in-vs-2008/

Tasks in the Control flow toolbox:

The Execute SQL Task:
This task is widely used in the packages.
http://www.sqlis.com/post/The-Execute-SQL-Task.aspx

http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx

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 .”
http://cschiopu.wordpress.com/2007/10/26/ssis-issue-with-sql-server-2005-stored-procedures-output-parameters/

Webservice task:
The below link has a document explaining the usage of webservice task in a clear manner.
http://pedrocgd.blogspot.com/2009/11/bi-stepbystep-ssis-calling-webservice.html

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.