Ok,
I have given that direction as parameter bcos i want use it like a condition there. That's not problem I can just keep 'queryout' there directly instead of direction as parameter.
But today Iam getting a diferent error when i try queryout in QA
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file
Please let me know the solution for this error. Is this any thing related to the permissions?
I am using SQL Server 2005 Management studio.
(Do I need to set any settings in the configurations like that ? bcos, I am just runing this in my local machine now . Or Do I need to Install SQL Server Express Edition?)
or is it some thing other than these settings ?
Your help could be of great use.
Thanks,