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,
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.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
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.
|Powered by Social Strata|