I am facing an issue with my OLEDB data source in the DFT
We are using procedures as data source in the DFT. Initially we did not have mapping for all the columns in the SP to the destination table. So we selected NULL for such missing mappings. Later point we got this mapping and we replaced NULL with the column name. But, this data type of the new column is not refreshing in the data source. I tried clicking the Refresh button in the advanced editor, in vain. Any help is appreciated on this. thanks!