Link to home
Start Free TrialLog in
Avatar of enrique_aeo
enrique_aeo

asked on

run a query and the result of this query must be taken to a text file

hi experts
What I need is to run a query and the result of this query must be taken to a text file without using DTS this has to be daily (through a JOB)

please help
SOLUTION
Avatar of netovsky
netovsky
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of enrique_aeo
enrique_aeo

ASKER

recommended using BCP, you think?
 but I do not know that tool
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
and where I execute these commands?
master..xp_cmdshell 'bcp master..sysobjects out c:\file.bcp -S -U -P -c '

d.o.s.?