August 31, 2009 at 8:18 am
Hello everyone.
I have some questions concerning Data Flow Transformations. I need to make some transformation of some data existing in a view into some other form. In T-SQL these functions are:
Concatenation (of two or more columns)
Conversion
Case When ...
Union
Union All
I have found the corresponding transformation tasks for concatenation and Conversion.
Concatenation --> Derived Column
Conversion --> Data Conversion
Also i have tried those
Also i did some research and i've found that the corresponding tasks for Union and Union ALL are:
Union --> Merge
Union All --> Union All
I haven't tested those so i need some confirmation.
I haven't found the corresponding data flow transformation (if exists) for the Case When T-SQL command.Also i would like to know if there is any transformation for the join operation between 2 tables.
So i need two more things:Corresponding data transformations for the CASE WHEN.. T-SQL command
and for the join operation.
I haven't used SSIS a lot so i dont know how they function. Any suggestions would be very helpful.
Thank you in advance.
August 31, 2009 at 10:16 am
The Conditional Split transformation is what you'll need to pull off a CASE statement. It will let you bucket, using expressions, your data in your pipleline and route each bucket down a different output where you can then perform additional transformations/validations/etc on the data.
As far as joining tables goes, look at using the Merge Join transformation for that one.
September 1, 2009 at 12:13 am
thanks for your advice
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply