I need to pass parameters for a sqlquery(not a Stored proc) in Oledb object of SSIS. I have tried to give the parameters as "?" it created corresponding parameters in @[User: format. While running through the option ExecuteSQL its working fine. But if we are running the application(by pressing F5 or directly), the application is not prompting for parameters.
The result is showing empty row too...