Hi All,
Need input for this requirement, in which we need to have a source query in any file can say configuration file for the job, from which need to pass the query to ODBC stage instead of hardcode the query in ODBC stage itself.
Thanks,
Kannan
Handling Query in ODBC stage
Moderators: chulett, rschirm, roy
There should be (I believe) an option to reference the sql filename in the stage and have it read it in at runtime. You need to do something like prefix it with {FILE} but I'm not positive of the syntax. A search with the proper terms should turn something up as we've discussed this before.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers