SQL Command Shell Extract Sample
This was an extract using the command shell that extracted table data to a text file on the file system on the server. /* AFS Feeds */ /* AFS Business Unit Feed – Command Shell */ EXEC xp_cmdshell ‘bcp “EXEC [<<Enter MAX DB Name Here>>].[dbo].[AFS_BUSUNIT]” queryout “D:\ExactShared\AFS_Xfer\busunit.txt” -T -c -t’ /* AFS…