Getting Started with Adobe After Effects - Part 6:
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 ·
SQL SERVER 2005
Tejas Shah's Blog
SQL SERVER: SSIS - Derived Column Data Flow Transformation
Jan 10 2010 2:03AM
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.
2. Configure Derived Column:
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:
3. That's it. Now just add it to Destination Column Mapping with your Database column.
Let me know your suggestions.
SQL SERVER: SSIS - Transfer Jobs Task
SQL SERVER: Execute Stored Procedure when SQL SERVER is started
. Read the original version
Post this to my facebook wall
This was a true life saver
Thanks, this helped me to refresh my memory
Very informative, I just learned something new
I disagree, this information is incorrect
to post a comment.
Copyright © Rivera Informatic Private Ltd