1
kudos
spam Kudos Remove

Working with SSIS Expressions

published 944 days, 15 hours, 22 minutes ago posted by sasa 954 days, 10 hours, 53 minutes ago
Thursday, October 22, 2009 3:37:29 PM GMT Monday, October 12, 2009 8:05:52 PM GMT

In SQL Server Integration Services (SSIS) Packages, expressions are everywhere. You may have worked with Expressions in some of the transformation tasks, such as the Derive Column Transformation, but did you know they can also be used to set the properties of many of the tasks and transformations, or even used to modify the values in your SSIS Variables? Let’s look at an example. What if you have to write a lookup query that pulls data from two databases on the same SQL Server but you’re not sure what th...

category: Warehousing | clicked: 2 | | source: sqlblog.com | show counter code
tags: SSIS

No comments yet, be the first one to post comment.

To post your comment please login or signup