DECLARE 
	@fileToUpload nvarchar(max) = 'D:\Test_file.csv',
	@sqlServerInstance nvarchar(max) = 'localhost',
	@sqlLoginName nvarchar(max) = '<Логин>',
	@sqlLoginPassword nvarchar(max) = '<Пароль>',
	@cmdOperationUpload varchar(8000); 

IF OBJECT_ID('tempdb..##tt_TemporaryTableTest') IS NOT NULL
	DROP TABLE ##tt_TemporaryTableTest;

CREATE TABLE ##tt_TemporaryTableTest
(
	[ID_VALUE1] [INT] NOT NULL,
    [ID_VALUE2] [NVARCHAR](30) NOT NULL,
	[ID_VALUE3] [INT] NOT NULL,
	[ID_VALUE4 [INT] NOT NULL,
	[ID_VALUE5] [INT] NOT NULL,
)

SET @cmdOperationUpload = 
	'bcp ##tt_TemporaryTableTest IN "' + @fileToUpload + '" ' + 
	'-e "';
EXEC master..xp_cmdshell @cmdOperationUpload, no_output;

select * FROM ##tt_TemporaryTableTest; 

GO
	CREATE PROCEDURE TestUpload AS
	BEGIN
		BULK INSERT test.dbo.Table1
		FROM 'D:\Test_file.csv'
		WITH (FIRSTROW = 2,
		MAXERRORS = 0, 
		CODEPAGE = '1251',
		FIELDTERMINATOR = ',')
	END;
GO

EXEC TestUpload;