question

tlenzmeier avatar image
tlenzmeier asked

Slowly Changing Dimension - Lookup/Union All

I am relatively new to creating slowly changing dimensions in my SSIS packages. So I beg your indulgence. After adding my OLE DB source, I then added the lookup transformation tool. After establishing the connection, I then select columns. I join my two ID columns and I'm left with a choice: or . If I leave the default selection (add new column), by the time I finish the SCD wizard I end up with an error in my Union All saying I have duplicate outputs. I am not sure if I should just create an alias for the "new column" or have the lookup replace the value. The field in question is called VendorCode and it is the unique value assigned to our vendors.
ssislookupsunion-allslowly-changing-dimension
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
satishseth143 avatar image
satishseth143 answered
You may have selected the VendorCode from available lookup columns. Since its already in your source, you do not have to select it from lookup columns. **Uncheck the checkbox**![alt text][1] [1]: /storage/temp/3827-untitled.png

untitled.png (51.2 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.