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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With