Menu
I need to be able to see derived column in the dataviewer. Please see image below for details.
I have tried disabling and enabling the data viewer, but that did'nt change anything for me.
846
To start using the Derived Column transformation, create an SSIS package. Next, drag a Data Flow component in the Control Flow, double-click the Data Flow component and drag a data source component. Then, configure the data source to connect to your database. Finally, add a Derived Column transformation component.
To use Data Viewer between Transformations, Double click on green connection that exists between two transformations, it will open Data Viewer Editor (Data Flow Path Editor). Data Viewer: This is the tab where we will be able to select the column those we want to include in Data View.
SSIS supports several types of data viewers. The one most commonly used is the grid data viewer, which displays the data in tabular format. However, you can also create data viewers that display histograms, scatter plot charts, or column charts.
Double click the data flow path that has the viewer enabled. Click on the Data Viewer tab. priceRefSource is probably listed in the Unused Columns list. Click on it, and then move it across to the Displayed Columns list.
122
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
