SSIS Control Flow Chart
Import_Recall_Campaigns_V2.xlsx
Import_Recall_Campaigns
| Database Mapping | Lookup | |||||||
|---|---|---|---|---|---|---|---|---|
| Column | Description | Table | Field | DB Type | Table | Field | ||
| U_IDMS_Make | @IDMS_REC_CAMPAIGN | U_IDMS_Make | NVARCHAR(50) | |||||
| U_IDMS_Description | @IDMS_REC_CAMPAIGN | U_IDMS_Description | NVARCHAR(254) | |||||
| U_IDMS_VIN | @IDMS_REC_CAMPAIGN | U_IDMS_VIN | NVARCHAR(50) | |||||
| U_IDMS_OEMCampaignNo | @IDMS_REC_CAMPAIGN | U_IDMS_OEMCampaignNo | NVARCHAR(50) | |||||
| U_IDMS_Type | @IDMS_REC_CAMPAIGN | U_IDMS_Type | NVARCHAR(50) | |||||
| U_IDMS_Source | @IDMS_REC_CAMPAIGN | U_IDMS_Source | NVARCHAR(50) | |||||
| U_IDMS_StartDate | @IDMS_REC_CAMPAIGN | U_IDMS_StartDate | TIMESTAMP | |||||
| U_IDMS_EndDate | @IDMS_REC_CAMPAIGN | U_IDMS_EndDate | TIMESTAMP | |||||
| U_IDMS_MainLaborCode | @IDMS_REC_CAMPAIGN | U_IDMS_MainLaborCode | NVARCHAR(50) | |||||
| U_IDMS_DTC | @IDMS_REC_CAMPAIGN | U_IDMS_DTC | NVARCHAR(50) | |||||
| U_IDMS_PackageCode | @IDMS_REC_CAMPAIGN | U_IDMS_PackageCode | NVARCHAR(50) | |||||
| U_IDMS_Priority | @IDMS_REC_CAMPAIGN | U_IDMS_Priority | NVARCHAR(50) | |||||
The following fields "U_IDMS_DIM_Company", "U_IDMS_DIM_Branch", "U_IDMS_DIM_Location" are extracted from "IDMS_USERLOGINSDETAILS_VIEW" using the Variable "ODParamUserLoginID", and are then imported in @IDMS_REC_CAMPAIGN.
Template Excel File
Import_Recall_Campaigns_V2.xlsx
Add Comment