SQL Server BULK INSERT

Open function

--to-allow advanced options to be changed.

EXEC sp_configure ' show advanced options ', 1

GO

--To update the currently configured value for advanced options. RECONFIGURE

GO

--to enable the feature. EXEC sp_configure ' xp_cmdshell ', 1

GO

--To update the currently configured value for this feature.

RECONFIGURE

GO

Master.. xp_cmdshell ' net use \\192.168.0.126\ftpfiles 12345678/user:server\administrator '

Tip: Execution of the command completes successfully. For example: Master. xp_cmdshell ' net use \\server\data lp/user:server\administrator '

SQL Server BULK INSERT