ssissalesforcecozyroc

Hardcoded Mapping to the Destination

I am trying to create a SSIS package for the interface between SQL Server and the Salesforce. I have created the connection between the systems and using a third party COZYROC Connector for SF connection and the data flow looks like below

enter image description here

I am not able to do any hardcoded mapping to the fields in Salesforce

While mapping it just shows the available input columns there is no way where I can set the hardcoded values for some fileds while doing an upsert. How can this be done.

Solution

  • Derived Column is what you are after.

    Dragged that from the tool box

    enter image description here

    Place it between you source and destination. Double click on it and you can add columns and default values. Leave the "Derived Column" option in the table as "add as new column"

    enter image description here

    Then those become available for mapping in the destination component.

    enter image description here