Untitled

	
	DROP TABLE IF EXISTS [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]

	CREATE TABLE [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]
	 (Регион [nvarchar](255) NULL,
	  Дата [nvarchar](255) NULL,
	  Значение [decimal](19,0) NULL);
	  	  
		  
BULK INSERT [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]
FROM '\\spb99-fss01\DataLakeDRP_SandBox\TEAM_21\Антон_БКД\Data\to_datalake\rosstat_indexes\info-stat-11-2023\01 промышленность\01-01 индекс промышленного производства.csv' 

WITH(
	FIRSTROW = 2,
	ROWTERMINATOR=',', 
	FIELDTERMINATOR=',', 
	FORMAT='csv',
	CODEPAGE='65001');

Select * FROM [SANDBOX_DB_TEAM_21].[dbo].[rosstat_idx_ipp]

Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 6, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 7, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 9, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 10, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 11, column 3 (Значение).
Msg 4864, Level 16, State 1, Line 10
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 12, column 3 (Значение).
Msg 4865, Level 16, State 1, Line 10
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 10
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 10
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

Completion time: 2024-01-15T14:29:26.6137359+03:00



Регион,Дата,ЗначениеРоссийская Федерация,01.01.2016,99.1Центральный федеральный округ,01.01.2016,94.1Белгородская область,01.01.2016,99.4Брянская область,01.01.2016,108.8Владимирская область,01.01.2016,96.0Воронежская область,01.01.2016,97.6Ивановская область,01.01.2016,109.5Калужская область,01.01.2016,86.8