I'm new to SSIS..
What I'm trying to do is to use calculated columns in a DSV.
I created the DSV with a single table from a relational database. The table has 2 columns and I added 2 calculated columns.
Everything is fine...I can preview the data, and it's ok
When I try to use the DSV in an OLE DB Source, I do select the DSV in the connection manager list, then select the table...but the calculated columns do not show up when I click the Preview button
What am I missing??
View Complete Post