General information
Forum:
Microsoft SQL Server
Title:
Problem with bcp utility
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only