Sonntag, 15. April 2012 03:56
Have a one SQL table in Target system With on identity column (Column1), Column2 and Column3(Column1+Column2) .
- Column3 is not a computed column.
- If Column3 Values is null then only we have concatenate Column1+Columns2
Column1 Column2 Column3 (Column1+Column2)
1 A 1A (Getting NUL From Source)
2 B 2B (Getting NUL From Source)
3 C CC (Column3 Value not null from source)
I have to implement this situation in SSIS Package.
Can any one put me in the right direction ?
Sonntag, 15. April 2012 06:17
First I think you need to create Store Procedure to check and your conditions ( If Column3 Values is null then only we have concatenate Column1+Columns2). Then you can use execute SQL Task to execute this. Or you can use script task.
I hope this is helpful.
Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
Sonntag, 15. April 2012 07:37Moderator
Create an update statement that you execute after the Data Flow Task (use Execute SQL Task)