HOW TO HARDCODE A VALUE IN SSIS DATAFLOW For Destination Column

• SSIS\SSRS\SSAS

  SSCertifiable

  Points: 6038

  More actions

  August 26, 2008 at 3:51 pm

  #127242

  I have a datafloe, WithIN I have a OLEDB source. Then I do my lots of business logic like splits, lookups and conversations. Then I have a OLEDB destination.

  NOW, In my OLEDB destination there are three columns which I have to populate with some hardcode values. Like---

  Col 1 - with "WM"

  Col 2 - with Getdate()

  Col 3 - with UserID().

  For example IN T-sql I can say that

  INSERT into A(

  col1

  col2

  col3)

  SELECT 'WM'

  GETDATE()

  USERID()

  How can I do this within dataflow.

  ONE WAY I AM THINKING OF HAVING defaults in the Table Itself. BUT this would be my last option as I am not the owner of the table.

  Thanks

• Mukti

  SSCrazy

  Points: 2826

  More actions

  August 28, 2008 at 12:21 pm

  #864622

  You can add Derived Column transformation, and in the Derived Column drop down select 'Add as new column'

• SSIS\SSRS\SSAS

  SSCertifiable

  Points: 6038

  More actions

  August 28, 2008 at 1:00 pm

  #864643

  Thanks Mukti... I believe We can do that. Other way i was thinking to add OLEDB source and use SQL COMMAND as query like

  SELECT 'GM', getdate(), user

  and then do the join to other results .

  BUt, since things changed here and I don't have to do it for rt now.

  thanks