Hi,

I have a data flow which loads data from a csv file to a target SQL table.
I have the data flow placed in a process flow and for logging the flow details to another sql table,i need to use a column value from the data flow in process flow procedures i have.
How can i get column value from the data flow?

This message has been edited. Last edited by: FP Mod Chuck,

Srajeevan

I just wanted to make you aware if you click on the data flow canvas a properties that includes Record Logging will appear. You can choose All Transactions which will create a flat file of all columns used in the data flow. Otherwise the only way I can see to accomplish logging to a sql table is by creating another data flow with that table as the target.

Hi Chuck,

Thanks for the workarounds.
You have answered my similar question and i am gonna try that solution.
SO i will close this questions as Solved.