Headed: http://community.9cbs.net/expert/topic/3717/3717728.xml? Temp = .3920404
CREATE procedure File2Table @ servername varchar (200), @ username varchar (200), @ password varchar (200), @ tbname varchar (500), @ filename varchar (1000), @ isout bitasdeclare @sql varchar (8000) if @tbname Like '%.%.%' beginset @ SQL = 'Master " @ TBNAME ' ' CASE WHEN @ iSout = 1 TEN' OUT 'ELSE' IN 'End '" ' @ filename ' " -w -s "' @ servername '" -u "' @ username '" -p "' @ password ' '' 'SELECT @SQLEXEC (@SQL) end
Execute exec file2table @ servername = 'mytomato', @ username = 'sa', @ password = '', @ TBNAME = 'Pubs.dbo.employee', @ filename = 'c: /zx.txt', @ isout = ' 1'
The results show that:
MASTER..XP_CMDSHELL 'BCP PUBS.DBO.EMPLOYEE OUT "C: /ZX.TXT" -w -s "127.0.0.1" -u "sa" -p "000000"
NULL starts replication ... NULL has been copied 43 lines. The size of the packet (bytes): 4096 clock time (ms): Total 94null
