Skip to Content
0
Former Member
Feb 03, 2009 at 12:38 PM

Read Data Manager prompt as transformation value during import

76 Views

Hi,

I have a file that has two of the columns required to populate dimensions. Another 4 of the dimensions can be added as new columns as they are static. However there are an additional two dimensions (TIME and LEGALENTITY) that I have added to the Import package as prompts however I am having trouble finding a way to link the transformation file to the prompts in the SSIS - any ideas? When running the new import package I am prompted for both TIME and LEGALENTITY, however the package fails with the message:

Mapping Error: The folloiwng doesn't exist in the data file header [LEGALENTITY, TIME]

Kind Regards,

Fiona