< p>The new column is displayed normally in the conditional split, as the source column and the target column.
In the ADO NET target (“Insert Specification”), the new column is only displayed on the left of the “Available Input Columns” The column (“Available Target Column”) is missing on the right side.
I’m sure my new list is now in the target table. Did I miss a step?
Update:
Interestingly, when I hover over the ADO NET Destination element, I receive this warning:
The new column named sold_price has been Add to the external database table. If necessary, use the advanced editor to refresh the available target columns.
However, the description requires “Advanced Editor”.
There is a “Refresh” at the bottom of the Advanced Editor. “Button. Click this button to add a new column to the “Available Target Columns” box.
I need to add a column during the ETL process. Except for the last one completed successfully All steps-ADO NET Destination (the “Insert Specs” element on the left).
The new column is displayed normally in the conditional split, as the source column and the target column.
In the ADO NET target (“Insert Specification”), the new column is only displayed on the left side of the “Available Input Column”, and the column is missing on the right (“Available Target Column”).
I’m sure My new listing is now in the target table. Did I miss a step?
Update:
Interestingly, when I hover over the ADO NET Destination element, I receive this warning:
The new column named sold_price has been Add to the external database table. If necessary, use the advanced editor to refresh the available target columns.
The above view is “Edit”.
< /p>
However, the description requires “Advanced Editor”.
There is a “Refresh” button at the bottom of the Advanced Editor. Click this button to add a new column Go to the “Available Target Columns” box.