Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This blog is for SQL SERVER developers. I am trying to publish the things that i face in my development career, so other developers can get help out of this BLOG.
Browse by Tags · View All
Tejas Shah 30
SQL SERVER 2005 11
SQL Server 10
SSIS 8
T-SQL 8
SQL Yoga 7
SSIS Task 7
SQLYoga 5
SQL Developer 5
DBA 5

Archive · View All
October 2012 5
October 2009 5
November 2012 3
December 2009 3
November 2009 3
September 2011 2
August 2010 2
April 2011 2
March 2010 2
September 2012 1

Tejas Shah's Blog

SQL SERVER: SSIS - Derived Column Data Flow Transformation

Jan 10 2010 2:03AM by Tejas Shah   


As I explained earlier about Foreach Loop Container. One of regular reader of blog send me an email about one issue.

Let me share that problem with all readers.

With this example, Foreach Loop Container, What to do if we want to save file name along with each row, so we can come to know that which row is from which file ?

This is very practical problem that we need to fix.

To solve this, I come up with following solution.

1. I used "Derived Column", one of Data Flow Transformations in Data Flow Operations.

SSIS For Each Loop Container II
2. Configure Derived Column:

SSIS Derived Column Data Flow Transformation Configuration

As we have variable, FileName, as defined in, SQL SERVER: SSIS - Foreach Loop Container. Here I used that variable as a new column. By dragging  that User variable to Expression.

By default it assign UNICODE STRING DataType to this new column. We need to change it by:

A. Right click on "Derived Column", Go to Show Advanced Editor
B. Set DataType to String as:

SSIS For Each Loop Container II Advanced Editor
3. That's it. Now just add it to Destination Column Mapping with your Database column.

Let me know your suggestions.


Republished from SQL Yoga [33 clicks].  Read the original version here [32134 clicks].
Tejas Shah
134 · 1% · 364
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect


Submit

Your Comment
Sign Up or Login to post a comment.
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]