How do you refresh the unmapped input columns in SSIS? The field exists in both the input and output columns but doesn't show when I try to resolve references.

Question

How do you refresh the unmapped input columns in SSIS? The field exists in both the input and output columns but doesn't show when I try to resolve references.

MK-8803 30

The sic field exists in both the Input and output columns. However, I'm unable to resolve references because the sic field is not showing in the unmapped Input columns. I'm using VS2019 and Sql Server 2017. I'm using an OLE db connection. User's image

User's image

Answer accepted by question author

0 additional answers

Your answer

Answer 1

ZoeHui-MSFT 41,536

Hi @MK-8803,

When an input path is disconnected or if there are any unmapped columns in the path, an error icon is displayed beside the corresponding data path. To simplify the resolution of column reference errors, the Resolve References editor allows you to link unmapped output columns with unmapped input columns for all paths in the execution tree.

Unmapped Input Columns (Destination)：
Columns from the downstream path that are not currently mapped

Please have a double check, or you may also show your design package and then we could do more analysis.

You may also check the video about the sample.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

MK-8803 30 Reputation points

2023-04-12T13:58:10.88+00:00

I have an OLE DB data source that pulls data from SQL Server 2017. I have a Sort following the data source. Data flow task I added 2 columns: sic and sicDescription to the Business Connect query.

The 2 new fields show in the Input and Output properties as expected I also clicked Refresh to update the fields

When I go to Resolve References the sic field is showing in the Unmapped output columns but the sic field is not showing in the Unmapped Input columns. I tried deleting the data source and sort tasks and recreating them. I tried removing the connection string to the database and re-adding it. I closed-reopened VS2019. I deleted the bin and obj folders. I'm still seeing the same behavior.
MK-8803 30 Reputation points

2023-04-12T17:45:03.97+00:00

I didn't have the latest version of SQL Server Integration Services Projects installed. It is now working. Thank you

Share via

How do you refresh the unmapped input columns in SSIS? The field exists in both the input and output columns but doesn't show when I try to resolve references.

0 additional answers

Your answer