Hi all,
I have multiple sql scripts in a local folder, and I'd like to run these scripts and based on these scripts create table, load data, add column, patch procedures/fucntions etc.
(I can't upload screenshot due to some reason though I am already registered here)
tOracleConnection_1 -> tFileList_1 -> tFileInputDelimited_1 -> tOracleRow_1
the problem is that I don't know how to get the sql statements from each file during iteration from tFileInputDelimited_1 component, and what to fill in Query parameter for TOracleRow_1. Perhaps, this can be done via contexts but I'm not sure how to do that either.
Any help? Thanks a lot