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,