Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Newly added column missing from Available Destination Columns in ADO NET Destination

I need to add a column to an ETL process. Completed all steps successfully except the last one - ADO NET Destination (the "Insert Specs" element on the left).

SSIS conditional split

The new column appears just fine in the Conditional Split, both as a source column and destination column.

In the ADO NET Destination ("Insert Specs") the new column only appears on the left in the "Available Input Columns" and it's missing on the right ("Available Destination Columns").

ADO NET Destination mappings

I know for sure my new column is present in the destination table. Did I miss a step along the way?


Update:
What's also interesting is that when I hover over the ADO NET Destination element I get this warning:

A new column with name sold_price has been added to the external database table. Use advanced editor to refresh available destination columns if needed.

ADO NET Destination - new column added

like image 368
Nelu Avatar asked Dec 03 '22 19:12

Nelu


1 Answers

The view above is for "Edit".

The instructions however ask for the "Advanced Editor".

SSIS advanced editor in Visual Studio

There is a "Refresh" button at the bottom of the Advanced Editor. Clicking this button adds the new column to the "Available Destination Columns" box.

SSIS advanced editor view in Visual Studio

like image 150
Nelu Avatar answered Dec 22 '22 08:12

Nelu