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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
and where I execute these commands?
master..xp_cmdshell 'bcp master..sysobjects out c:\file.bcp -S -U -P -c '
d.o.s.?
master..xp_cmdshell 'bcp master..sysobjects out c:\file.bcp -S -U -P -c '
d.o.s.?
ASKER
but I do not know that tool