SQL Server – Integration Services – How To

Group Tasks

Click a task, hold down the control key, click another task, right click, and select Group.

Add Annotation

Right click, and select Add Annotation. To add a line separator, press control-enter.

Variables

Right click, and select Variables.

Derived Column

For example, add a derived column between the source and destination of a data flow task.

A sample expression is ISNULL(ScriptureReference) || LTRIM(RTRIM(ScriptureReference)) == “” ? Commentary : Commentary + ” (” + ScriptureReference + “)”

Script Task

System.Windows.Forms.MessageBox.Show
(
“greeting=” +
Dts.Variables[“User::greeting”].Value.ToString()
);

Remember to register the variables as ReadOnlyVariables or ReadWriteVariables.

DataProfileViewer

Suitable natural keys that are candidate primary keys is one of the offering of this extensive tool.

This entry was posted on August 30, 2009 at 2:04 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL Server – Integration Services – How To”

Mr WordPress Says:
August 30, 2009 at 2:04 am | Reply
Hi, this is a comment.
To delete a comment, just log in, and view the posts’ comments, there you will have the option to edit or delete them.

Ken Adeniji's Blog