Handling Query in ODBC stage

[kannantechno]

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

[ArndW]

You can use job parameters to pass in dynamic query statements for the ODBC stage.

[chulett]

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.