CODEWITHSUNDEEP
sql-serverssisetlderived-column
Rachel
Rachel

Reputation: 218

SSIS derived Column (DateKey)

I am trying to create a derived column that will convert the date into a date keys, apparently, I got the expression right but when I run the package and go to my destination table I don't see my derived column created. I am not sure what could be the error, please help! enter image description here

Upvotes: 1

Views: 376

Answers (2)

Hadi
Hadi

Reputation: 37313

The Issue

You create a derived column, but you didn't maped it to a destination column (it doesn't create a column automatically in the OLEDB Destination)

enter image description here

So you have to create a new column in the destination table, and Map the derived column to it like shown in the image above.

Upvotes: 2

Prabhat G
Prabhat G

Reputation: 3029

From the mapping image, it is clear that you haven't mapped it. Ideal steps are:

  1. Create a new column in database.table
  2. Write the expression for derived column.
  3. Map the derived column with one created in db.

Upvotes: 0

Related Questions