Hi,
I'm trying to transfer data from query to a text.txt type file.

I can do it with the wizard and through the creation of a package but the problem is that I can only use the content of a limited query...Example: I can say in my query that I need the inventory of a client (ex.: client #1) "Select * from inventory where customer=1" but I cannot change the query during the execution of the package.

But I need the transfer to be dynamic. The query should adapt itself for every client.

So I need to use the bcp function to transfer my data, but query analyser does not recognize it. Example: bcp "querySql" queryout test.txt. Query analyzer is saying: Could not find stored procedure bcp.

Any suggestions...

Thanks!
-Michael