Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
declare @FilePath varchar(200) declare @FileName varchar(100) declare @FileDirectory varchar(100) declare @Query varchar(300) set @FilePath = '"\\nd\gl\AppArc\CSE\PQ\' set @FileDirectory = 'data\' set @FileName = 'dataFile.csv"' set @Query = ' bcp PER.dbo.CustomerAddress in '+ @FilePath+@FileDirectory+@FileName + ' -c -t, -S "der900" -U "temp" -P "temp"' print @Query exec master..xp_cmdshell @Query
Join the community of 500,000 technology professionals and ask your questions.