How insert Identity Value into Other column in Same Table

Question

Hi

Have a one SQL table in Target system With on identity column (Column1), Column2 and Column3(Column1+Column2) .

Note:

1.        Column3 is not a computed column.
2.        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 ?

Answer 1

Hi,

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

MyBlog

Answer 2

Alter alternatives:

Create an update statement that you execute after the Data Flow Task (use Execute SQL Task)

Create the identity within SSIS with a Rownumber Transformation (example 1, example 2) or a Script Component

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter