Newly added column missing from Available Destination Columns in ADO NET Destination
ssis, visual-studio, visual-studio-2008
Solution
The view above is for "Edit".
The instructions however ask for the "Advanced Editor".
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.
Problem
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). 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`"). 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.