DS 8.5
OS Win
DB SQL Server 2008
All I am trying to do is, pass the whole SQL Query at the run time. I used SQL Server EE stage to read the data from SQL Server. In the Query Option i passed a variable name. At the run time i am passing the below query
Code: Select all
SELECT job_nme + '|' as JOB_NAME FROM dbo.table_name where enabled_flg = 1 order by 1
Code: Select all
main_program: PATH search failure:
main_program: Could not locate operator definition, wrapper, or Unix command for " as JOB_NAME FROM dbo.table_name where enabled_flg = 1 order by 1 ) x"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
Can any one have any clue ? Any guidance?
Please!
Note: I added the Disable combination is true