Wayne Atherton
asked on
sqlcmd for xml
I have an external .sql file which works 100% is SSMS, which produces well formed xml. However, as soon as I try and create a sql job the out put is on continous string, as apposed to well formed xml.
here is the cmd being called inside the job:
sqlcmd -X -h-1 -y 0 -i "D:\API\Export\MessagesXML .sql" -d dbname -S localhost\instance -o "D:\API\Export\Messages.xm l"
This is being run as a 'Operating System (CmdExec) job, any help would be appreciated.
here is the cmd being called inside the job:
sqlcmd -X -h-1 -y 0 -i "D:\API\Export\MessagesXML
This is being run as a 'Operating System (CmdExec) job, any help would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER