How to read/write or copy/paste text file locally using Stored procedure?

Question

Hi

My Stored Procedure is using Bulk Insert Task. As per requirement of Bulk Insert, the text file should be on same server where database is.

Now file is residing on another machine. But database server can access file using shared network drive.

Now question is How my stored procedure can read or copy the file from network drive and write or paste it locally before running the Bulk Insert?

Thanks

Answer 1

You can enable xp_cmdshell and use it to issue a copy command to the shell.

But then, why would you need that? SQL Server supports bulk insert from remote locations.