dts导出到excel
表:
EXEC master..xp_cmdshell 'bcp uttemp.dbo.abc out c:\temp01.xls -c -q -S"192.168.0.157" -U"sa" -P"777"'
sql语句:
EXEC master..xp_cmdshell 'bcp "select dt from uttemp.dbo.abc" queryout c:\temp01.xls -c -q -S"192.168.0.157" -U"sa" -P"777"'