当前位置： 文江博客话题详情

将 5 gig 文件导入表时出错

发布于 2024-12-23 16:19:02 字数 27138 浏览 0 评论 0原文

我正在尝试批量插入表：

use SalesDWH

go


BULK INSERT dbo.npi
 FROM 'S:\tmp\npi.csv' WITH (FIELDTERMINATOR=',',ROWTERMINATOR='\n',lastrow=200,firstrow=2)

并收到此错误：

Msg 4866, Level 16, State 8, Line 3
The bulk load failed. The column is too long in the data file for row 1, column 329. Verify that the field terminator and row terminator are specified correctly.
Msg 7301, Level 16, State 2, Line 3
Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

我还尝试使用 sql 导入和导出向导来导入文件。它是用逗号分隔的，我收到这些错误：

Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Other Provider Identifier Issuer_5" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
 (SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task 1: The "output column "Other Provider Identifier Issuer_5" (514)" failed because truncation occurred, and the truncation row disposition on "output column "Other Provider Identifier Issuer_5" (514)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
 (SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "S:\tmp\nppes\npidata_20050523-20111114.csv" on data row 79.
 (SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - npidata_20050523-20111114_csv" (1) returned error code 0xC0202092.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)

我知道我的字段绝对足够大。下面是该表的创建语句：

USE [SalesDWH]
GO

/****** Object:  Table [dbo].[npi]    Script Date: 12/30/2011 15:28:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[npi](
    [NPI] [varchar](80) NULL,
    [Entity Type Code] [varchar](80) NULL,
    [Replacement NPI] [varchar](80) NULL,
    [Employer Identification Number (EIN)] [varchar](80) NULL,
    [Provider Organization Name (Legal Business Name)] [varchar](80) NULL,
    [Provider Last Name (Legal Name)] [varchar](80) NULL,
    [Provider First Name] [varchar](80) NULL,
    [Provider Middle Name] [varchar](80) NULL,
    [Provider Name Prefix Text] [varchar](80) NULL,
    [Provider Name Suffix Text] [varchar](80) NULL,
    [Provider Credential Text] [varchar](80) NULL,
    [Provider Other Organization Name] [varchar](80) NULL,
    [Provider Other Organization Name Type Code] [varchar](80) NULL,
    [Provider Other Last Name] [varchar](80) NULL,
    [Provider Other First Name] [varchar](80) NULL,
    [Provider Other Middle Name] [varchar](80) NULL,
    [Provider Other Name Prefix Text] [varchar](80) NULL,
    [Provider Other Name Suffix Text] [varchar](80) NULL,
    [Provider Other Credential Text] [varchar](80) NULL,
    [Provider Other Last Name Type Code] [varchar](80) NULL,
    [Provider First Line Business Mailing Address] [varchar](80) NULL,
    [Provider Second Line Business Mailing Address] [varchar](80) NULL,
    [Provider Business Mailing Address City Name] [varchar](80) NULL,
    [Provider Business Mailing Address State Name] [varchar](80) NULL,
    [Provider Business Mailing Address Postal Code] [varchar](80) NULL,
    [Provider Business Mailing Address Country Code (If outside U S )] [varchar](80) NULL,
    [Provider Business Mailing Address Telephone Number] [varchar](80) NULL,
    [Provider Business Mailing Address Fax Number] [varchar](80) NULL,
    [Provider First Line Business Practice Location Address] [varchar](80) NULL,
    [Provider Second Line Business Practice Location Address] [varchar](80) NULL,
    [Provider Business Practice Location Address City Name] [varchar](80) NULL,
    [Provider Business Practice Location Address State Name] [varchar](80) NULL,
    [Provider Business Practice Location Address Postal Code] [varchar](80) NULL,
    [Provider Business Practice Location Address Country Code (If outside U S )] [varchar](80) NULL,
    [Provider Business Practice Location Address Telephone Number] [varchar](80) NULL,
    [Provider Business Practice Location Address Fax Number] [varchar](80) NULL,
    [Provider Enumeration Date] [varchar](80) NULL,
    [Last Update Date] [varchar](80) NULL,
    [NPI Deactivation Reason Code] [varchar](80) NULL,
    [NPI Deactivation Date] [varchar](80) NULL,
    [NPI Reactivation Date] [varchar](80) NULL,
    [Provider Gender Code] [varchar](80) NULL,
    [Authorized Official Last Name] [varchar](80) NULL,
    [Authorized Official First Name] [varchar](80) NULL,
    [Authorized Official Middle Name] [varchar](80) NULL,
    [Authorized Official Title or Position] [varchar](80) NULL,
    [Authorized Official Telephone Number] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_1] [varchar](80) NULL,
    [Provider License Number_1] [varchar](80) NULL,
    [Provider License Number State Code_1] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_1] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_2] [varchar](80) NULL,
    [Provider License Number_2] [varchar](80) NULL,
    [Provider License Number State Code_2] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_2] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_3] [varchar](80) NULL,
    [Provider License Number_3] [varchar](80) NULL,
    [Provider License Number State Code_3] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_3] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_4] [varchar](80) NULL,
    [Provider License Number_4] [varchar](80) NULL,
    [Provider License Number State Code_4] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_4] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_5] [varchar](80) NULL,
    [Provider License Number_5] [varchar](80) NULL,
    [Provider License Number State Code_5] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_5] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_6] [varchar](80) NULL,
    [Provider License Number_6] [varchar](80) NULL,
    [Provider License Number State Code_6] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_6] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_7] [varchar](80) NULL,
    [Provider License Number_7] [varchar](80) NULL,
    [Provider License Number State Code_7] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_7] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_8] [varchar](80) NULL,
    [Provider License Number_8] [varchar](80) NULL,
    [Provider License Number State Code_8] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_8] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_9] [varchar](80) NULL,
    [Provider License Number_9] [varchar](80) NULL,
    [Provider License Number State Code_9] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_9] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_10] [varchar](80) NULL,
    [Provider License Number_10] [varchar](80) NULL,
    [Provider License Number State Code_10] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_10] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_11] [varchar](80) NULL,
    [Provider License Number_11] [varchar](80) NULL,
    [Provider License Number State Code_11] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_11] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_12] [varchar](80) NULL,
    [Provider License Number_12] [varchar](80) NULL,
    [Provider License Number State Code_12] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_12] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_13] [varchar](80) NULL,
    [Provider License Number_13] [varchar](80) NULL,
    [Provider License Number State Code_13] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_13] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_14] [varchar](80) NULL,
    [Provider License Number_14] [varchar](80) NULL,
    [Provider License Number State Code_14] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_14] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_15] [varchar](80) NULL,
    [Provider License Number_15] [varchar](80) NULL,
    [Provider License Number State Code_15] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_15] [varchar](80) NULL,
    [Other Provider Identifier_1] [varchar](80) NULL,
    [Other Provider Identifier Type Code_1] [varchar](80) NULL,
    [Other Provider Identifier State_1] [varchar](80) NULL,
    [Other Provider Identifier Issuer_1] [varchar](80) NULL,
    [Other Provider Identifier_2] [varchar](80) NULL,
    [Other Provider Identifier Type Code_2] [varchar](80) NULL,
    [Other Provider Identifier State_2] [varchar](80) NULL,
    [Other Provider Identifier Issuer_2] [varchar](80) NULL,
    [Other Provider Identifier_3] [varchar](80) NULL,
    [Other Provider Identifier Type Code_3] [varchar](80) NULL,
    [Other Provider Identifier State_3] [varchar](80) NULL,
    [Other Provider Identifier Issuer_3] [varchar](80) NULL,
    [Other Provider Identifier_4] [varchar](80) NULL,
    [Other Provider Identifier Type Code_4] [varchar](80) NULL,
    [Other Provider Identifier State_4] [varchar](80) NULL,
    [Other Provider Identifier Issuer_4] [varchar](80) NULL,
    [Other Provider Identifier_5] [varchar](80) NULL,
    [Other Provider Identifier Type Code_5] [varchar](80) NULL,
    [Other Provider Identifier State_5] [varchar](80) NULL,
    [Other Provider Identifier Issuer_5] [varchar](80) NULL,
    [Other Provider Identifier_6] [varchar](80) NULL,
    [Other Provider Identifier Type Code_6] [varchar](80) NULL,
    [Other Provider Identifier State_6] [varchar](80) NULL,
    [Other Provider Identifier Issuer_6] [varchar](80) NULL,
    [Other Provider Identifier_7] [varchar](80) NULL,
    [Other Provider Identifier Type Code_7] [varchar](80) NULL,
    [Other Provider Identifier State_7] [varchar](80) NULL,
    [Other Provider Identifier Issuer_7] [varchar](80) NULL,
    [Other Provider Identifier_8] [varchar](80) NULL,
    [Other Provider Identifier Type Code_8] [varchar](80) NULL,
    [Other Provider Identifier State_8] [varchar](80) NULL,
    [Other Provider Identifier Issuer_8] [varchar](80) NULL,
    [Other Provider Identifier_9] [varchar](80) NULL,
    [Other Provider Identifier Type Code_9] [varchar](80) NULL,
    [Other Provider Identifier State_9] [varchar](80) NULL,
    [Other Provider Identifier Issuer_9] [varchar](80) NULL,
    [Other Provider Identifier_10] [varchar](80) NULL,
    [Other Provider Identifier Type Code_10] [varchar](80) NULL,
    [Other Provider Identifier State_10] [varchar](80) NULL,
    [Other Provider Identifier Issuer_10] [varchar](80) NULL,
    [Other Provider Identifier_11] [varchar](80) NULL,
    [Other Provider Identifier Type Code_11] [varchar](80) NULL,
    [Other Provider Identifier State_11] [varchar](80) NULL,
    [Other Provider Identifier Issuer_11] [varchar](80) NULL,
    [Other Provider Identifier_12] [varchar](80) NULL,
    [Other Provider Identifier Type Code_12] [varchar](80) NULL,
    [Other Provider Identifier State_12] [varchar](80) NULL,
    [Other Provider Identifier Issuer_12] [varchar](80) NULL,
    [Other Provider Identifier_13] [varchar](80) NULL,
    [Other Provider Identifier Type Code_13] [varchar](80) NULL,
    [Other Provider Identifier State_13] [varchar](80) NULL,
    [Other Provider Identifier Issuer_13] [varchar](80) NULL,
    [Other Provider Identifier_14] [varchar](80) NULL,
    [Other Provider Identifier Type Code_14] [varchar](80) NULL,
    [Other Provider Identifier State_14] [varchar](80) NULL,
    [Other Provider Identifier Issuer_14] [varchar](80) NULL,
    [Other Provider Identifier_15] [varchar](80) NULL,
    [Other Provider Identifier Type Code_15] [varchar](80) NULL,
    [Other Provider Identifier State_15] [varchar](80) NULL,
    [Other Provider Identifier Issuer_15] [varchar](80) NULL,
    [Other Provider Identifier_16] [varchar](80) NULL,
    [Other Provider Identifier Type Code_16] [varchar](80) NULL,
    [Other Provider Identifier State_16] [varchar](80) NULL,
    [Other Provider Identifier Issuer_16] [varchar](80) NULL,
    [Other Provider Identifier_17] [varchar](80) NULL,
    [Other Provider Identifier Type Code_17] [varchar](80) NULL,
    [Other Provider Identifier State_17] [varchar](80) NULL,
    [Other Provider Identifier Issuer_17] [varchar](80) NULL,
    [Other Provider Identifier_18] [varchar](80) NULL,
    [Other Provider Identifier Type Code_18] [varchar](80) NULL,
    [Other Provider Identifier State_18] [varchar](80) NULL,
    [Other Provider Identifier Issuer_18] [varchar](80) NULL,
    [Other Provider Identifier_19] [varchar](80) NULL,
    [Other Provider Identifier Type Code_19] [varchar](80) NULL,
    [Other Provider Identifier State_19] [varchar](80) NULL,
    [Other Provider Identifier Issuer_19] [varchar](80) NULL,
    [Other Provider Identifier_20] [varchar](80) NULL,
    [Other Provider Identifier Type Code_20] [varchar](80) NULL,
    [Other Provider Identifier State_20] [varchar](80) NULL,
    [Other Provider Identifier Issuer_20] [varchar](80) NULL,
    [Other Provider Identifier_21] [varchar](80) NULL,
    [Other Provider Identifier Type Code_21] [varchar](80) NULL,
    [Other Provider Identifier State_21] [varchar](80) NULL,
    [Other Provider Identifier Issuer_21] [varchar](80) NULL,
    [Other Provider Identifier_22] [varchar](80) NULL,
    [Other Provider Identifier Type Code_22] [varchar](80) NULL,
    [Other Provider Identifier State_22] [varchar](80) NULL,
    [Other Provider Identifier Issuer_22] [varchar](80) NULL,
    [Other Provider Identifier_23] [varchar](80) NULL,
    [Other Provider Identifier Type Code_23] [varchar](80) NULL,
    [Other Provider Identifier State_23] [varchar](80) NULL,
    [Other Provider Identifier Issuer_23] [varchar](80) NULL,
    [Other Provider Identifier_24] [varchar](80) NULL,
    [Other Provider Identifier Type Code_24] [varchar](80) NULL,
    [Other Provider Identifier State_24] [varchar](80) NULL,
    [Other Provider Identifier Issuer_24] [varchar](80) NULL,
    [Other Provider Identifier_25] [varchar](80) NULL,
    [Other Provider Identifier Type Code_25] [varchar](80) NULL,
    [Other Provider Identifier State_25] [varchar](80) NULL,
    [Other Provider Identifier Issuer_25] [varchar](80) NULL,
    [Other Provider Identifier_26] [varchar](80) NULL,
    [Other Provider Identifier Type Code_26] [varchar](80) NULL,
    [Other Provider Identifier State_26] [varchar](80) NULL,
    [Other Provider Identifier Issuer_26] [varchar](80) NULL,
    [Other Provider Identifier_27] [varchar](80) NULL,
    [Other Provider Identifier Type Code_27] [varchar](80) NULL,
    [Other Provider Identifier State_27] [varchar](80) NULL,
    [Other Provider Identifier Issuer_27] [varchar](80) NULL,
    [Other Provider Identifier_28] [varchar](80) NULL,
    [Other Provider Identifier Type Code_28] [varchar](80) NULL,
    [Other Provider Identifier State_28] [varchar](80) NULL,
    [Other Provider Identifier Issuer_28] [varchar](80) NULL,
    [Other Provider Identifier_29] [varchar](80) NULL,
    [Other Provider Identifier Type Code_29] [varchar](80) NULL,
    [Other Provider Identifier State_29] [varchar](80) NULL,
    [Other Provider Identifier Issuer_29] [varchar](80) NULL,
    [Other Provider Identifier_30] [varchar](80) NULL,
    [Other Provider Identifier Type Code_30] [varchar](80) NULL,
    [Other Provider Identifier State_30] [varchar](80) NULL,
    [Other Provider Identifier Issuer_30] [varchar](80) NULL,
    [Other Provider Identifier_31] [varchar](80) NULL,
    [Other Provider Identifier Type Code_31] [varchar](80) NULL,
    [Other Provider Identifier State_31] [varchar](80) NULL,
    [Other Provider Identifier Issuer_31] [varchar](80) NULL,
    [Other Provider Identifier_32] [varchar](80) NULL,
    [Other Provider Identifier Type Code_32] [varchar](80) NULL,
    [Other Provider Identifier State_32] [varchar](80) NULL,
    [Other Provider Identifier Issuer_32] [varchar](80) NULL,
    [Other Provider Identifier_33] [varchar](80) NULL,
    [Other Provider Identifier Type Code_33] [varchar](80) NULL,
    [Other Provider Identifier State_33] [varchar](80) NULL,
    [Other Provider Identifier Issuer_33] [varchar](80) NULL,
    [Other Provider Identifier_34] [varchar](80) NULL,
    [Other Provider Identifier Type Code_34] [varchar](80) NULL,
    [Other Provider Identifier State_34] [varchar](80) NULL,
    [Other Provider Identifier Issuer_34] [varchar](80) NULL,
    [Other Provider Identifier_35] [varchar](80) NULL,
    [Other Provider Identifier Type Code_35] [varchar](80) NULL,
    [Other Provider Identifier State_35] [varchar](80) NULL,
    [Other Provider Identifier Issuer_35] [varchar](80) NULL,
    [Other Provider Identifier_36] [varchar](80) NULL,
    [Other Provider Identifier Type Code_36] [varchar](80) NULL,
    [Other Provider Identifier State_36] [varchar](80) NULL,
    [Other Provider Identifier Issuer_36] [varchar](80) NULL,
    [Other Provider Identifier_37] [varchar](80) NULL,
    [Other Provider Identifier Type Code_37] [varchar](80) NULL,
    [Other Provider Identifier State_37] [varchar](80) NULL,
    [Other Provider Identifier Issuer_37] [varchar](80) NULL,
    [Other Provider Identifier_38] [varchar](80) NULL,
    [Other Provider Identifier Type Code_38] [varchar](80) NULL,
    [Other Provider Identifier State_38] [varchar](80) NULL,
    [Other Provider Identifier Issuer_38] [varchar](80) NULL,
    [Other Provider Identifier_39] [varchar](80) NULL,
    [Other Provider Identifier Type Code_39] [varchar](80) NULL,
    [Other Provider Identifier State_39] [varchar](80) NULL,
    [Other Provider Identifier Issuer_39] [varchar](80) NULL,
    [Other Provider Identifier_40] [varchar](80) NULL,
    [Other Provider Identifier Type Code_40] [varchar](80) NULL,
    [Other Provider Identifier State_40] [varchar](80) NULL,
    [Other Provider Identifier Issuer_40] [varchar](80) NULL,
    [Other Provider Identifier_41] [varchar](80) NULL,
    [Other Provider Identifier Type Code_41] [varchar](80) NULL,
    [Other Provider Identifier State_41] [varchar](80) NULL,
    [Other Provider Identifier Issuer_41] [varchar](80) NULL,
    [Other Provider Identifier_42] [varchar](80) NULL,
    [Other Provider Identifier Type Code_42] [varchar](80) NULL,
    [Other Provider Identifier State_42] [varchar](80) NULL,
    [Other Provider Identifier Issuer_42] [varchar](80) NULL,
    [Other Provider Identifier_43] [varchar](80) NULL,
    [Other Provider Identifier Type Code_43] [varchar](80) NULL,
    [Other Provider Identifier State_43] [varchar](80) NULL,
    [Other Provider Identifier Issuer_43] [varchar](80) NULL,
    [Other Provider Identifier_44] [varchar](80) NULL,
    [Other Provider Identifier Type Code_44] [varchar](80) NULL,
    [Other Provider Identifier State_44] [varchar](80) NULL,
    [Other Provider Identifier Issuer_44] [varchar](80) NULL,
    [Other Provider Identifier_45] [varchar](80) NULL,
    [Other Provider Identifier Type Code_45] [varchar](80) NULL,
    [Other Provider Identifier State_45] [varchar](80) NULL,
    [Other Provider Identifier Issuer_45] [varchar](80) NULL,
    [Other Provider Identifier_46] [varchar](80) NULL,
    [Other Provider Identifier Type Code_46] [varchar](80) NULL,
    [Other Provider Identifier State_46] [varchar](80) NULL,
    [Other Provider Identifier Issuer_46] [varchar](80) NULL,
    [Other Provider Identifier_47] [varchar](80) NULL,
    [Other Provider Identifier Type Code_47] [varchar](80) NULL,
    [Other Provider Identifier State_47] [varchar](80) NULL,
    [Other Provider Identifier Issuer_47] [varchar](80) NULL,
    [Other Provider Identifier_48] [varchar](80) NULL,
    [Other Provider Identifier Type Code_48] [varchar](80) NULL,
    [Other Provider Identifier State_48] [varchar](80) NULL,
    [Other Provider Identifier Issuer_48] [varchar](80) NULL,
    [Other Provider Identifier_49] [varchar](80) NULL,
    [Other Provider Identifier Type Code_49] [varchar](80) NULL,
    [Other Provider Identifier State_49] [varchar](80) NULL,
    [Other Provider Identifier Issuer_49] [varchar](80) NULL,
    [Other Provider Identifier_50] [varchar](80) NULL,
    [Other Provider Identifier Type Code_50] [varchar](80) NULL,
    [Other Provider Identifier State_50] [varchar](80) NULL,
    [Other Provider Identifier Issuer_50] [varchar](80) NULL,
    [Is Sole Proprietor] [varchar](80) NULL,
    [Is Organization Subpart] [varchar](80) NULL,
    [Parent Organization LBN] [varchar](80) NULL,
    [Parent Organization TIN] [varchar](80) NULL,
    [Authorized Official Name Prefix Text] [varchar](80) NULL,
    [Authorized Official Name Suffix Text] [varchar](80) NULL,
    [Authorized Official Credential Text] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_1] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_2] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_3] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_4] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_5] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_6] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_7] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_8] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_9] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_10] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_11] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_12] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_13] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_14] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_15] [varchar](80) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

我确信没有任何列大于 80 个字符。我也尝试将其更改为 500 个字符，但仍然收到相同的错误。

我做错了什么？

为什么我无法导入该文件？

以下是其中一行的示例： "139236748349","1","","","","GRUrt3NERT","乔治","M","博士","","MD","","","", "","","","","","","7234900 FANNIN ST","套房4423400","休斯顿","德克萨斯州","770523442900","美国","713334351227000","713g25127082","792300 范宁街","套房423400","休斯顿","德克萨斯州","7705ef242900","美国","7132225127000","713512ff27082","05/23/2005","01/22/2009","",""," ”,“M ","","","","","","207VE0f2f102X","E02f945","TX","Y","","","","","","" 、""、""、""、""、""、""、""、""、""、""、""、""、""、""、" ","","","","","","","","","","","","","","","","", ""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、"" ,"","","82f4 380J","04","TX","FT.BEND/MONT","B2f33159","02","TX","","8432335J","04","TX","BRAZORIA", “8dd2047G”，“01”，“TX”，“蓝色十字与蓝盾”、“84sd2282J”、“04”、“TX”、“哈里斯”县”，””，””，””，””，””，””，””，””，””，””，””，””，””，””，””，”” ,"","","","","","","" 、""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、" "、""、""、""、""、""、""、""、""、" ","","","","","","","","","","","","","","","","", ""、""、""、""、""、""、""、""、""、 ""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、"" 、""、""、""、""、""、""、""、""、"" ,"","","","","","","","","","","","","","","",""," ","","","","","","","","", ""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、""、"" 、""、""、""、""、""、""、""、""、"" ,"","","","","","","","","","","","","","","",""," "、""、""、""、""、""、""、""、""、" ","","","","N","","","","","","","","","","","","" 、""、""、""、""、""、""、""、""、""

只是更新...我将所有字段更改为 nvarchar(max)

，但仍然收到这个可怕的错误：

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)
    Messages
    * Warning 0x80049304: Data Flow Task 1: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To resolve, run this package as an administrator, or on the system's console.
     (SQL Server Import and Export Wizard)


- Prepare for Execute (Success)

- Pre-execute (Success)
    Messages
    * Information 0x402090dc: Data Flow Task 1: The processing of file "S:\tmp\nppes\npidata_20050523-20111114.csv" has started.
     (SQL Server Import and Export Wizard)


- Executing (Error)
    Messages
    * Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Other Provider Identifier Issuer_5" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
     (SQL Server Import and Export Wizard)

    * Error 0xc020902a: Data Flow Task 1: The "output column "Other Provider Identifier Issuer_5" (514)" failed because truncation occurred, and the truncation row disposition on "output column "Other Provider Identifier Issuer_5" (514)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
     (SQL Server Import and Export Wizard)

    * Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "S:\tmp\nppes\npidata_20050523-20111114.csv" on data row 79.
     (SQL Server Import and Export Wizard)

    * Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - npidata_20050523-20111114_csv" (1) returned error code 0xC0202092.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
     (SQL Server Import and Export Wizard)


- Copying to [dbo].[npidata_20050523-20111114] (Stopped)

- Post-execute (Success)
    Messages
    * Information 0x402090dd: Data Flow Task 1: The processing of file "S:\tmp\nppes\npidata_20050523-20111114.csv" has ended.
     (SQL Server Import and Export Wizard)

    * Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - npidata_20050523-20111114" (1326)" has started.
     (SQL Server Import and Export Wizard)

    * Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion  in "component "Destination - npidata_20050523-20111114" (1326)" has ended.
     (SQL Server Import and Export Wizard)

    * Information 0x4004300b: Data Flow Task 1: "component "Destination - npidata_20050523-20111114" (1326)" wrote 58 rows.
     (SQL Server Import and Export Wizard)
原文

I am trying to do bulk insert into a table:

use SalesDWH

go


BULK INSERT dbo.npi
 FROM 'S:\tmp\npi.csv' WITH (FIELDTERMINATOR=',',ROWTERMINATOR='\n',lastrow=200,firstrow=2)

and getting this error:

Msg 4866, Level 16, State 8, Line 3
The bulk load failed. The column is too long in the data file for row 1, column 329. Verify that the field terminator and row terminator are specified correctly.
Msg 7301, Level 16, State 2, Line 3
Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

I also tried to use sql import and export wizard to import the file. It is comma-delimited and I am getting these errors:

Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Other Provider Identifier Issuer_5" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
 (SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task 1: The "output column "Other Provider Identifier Issuer_5" (514)" failed because truncation occurred, and the truncation row disposition on "output column "Other Provider Identifier Issuer_5" (514)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
 (SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "S:\tmp\nppes\npidata_20050523-20111114.csv" on data row 79.
 (SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - npidata_20050523-20111114_csv" (1) returned error code 0xC0202092.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)

I know that my fields are definitely big enough. Here's the create statement for the table:

USE [SalesDWH]
GO

/****** Object:  Table [dbo].[npi]    Script Date: 12/30/2011 15:28:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[npi](
    [NPI] [varchar](80) NULL,
    [Entity Type Code] [varchar](80) NULL,
    [Replacement NPI] [varchar](80) NULL,
    [Employer Identification Number (EIN)] [varchar](80) NULL,
    [Provider Organization Name (Legal Business Name)] [varchar](80) NULL,
    [Provider Last Name (Legal Name)] [varchar](80) NULL,
    [Provider First Name] [varchar](80) NULL,
    [Provider Middle Name] [varchar](80) NULL,
    [Provider Name Prefix Text] [varchar](80) NULL,
    [Provider Name Suffix Text] [varchar](80) NULL,
    [Provider Credential Text] [varchar](80) NULL,
    [Provider Other Organization Name] [varchar](80) NULL,
    [Provider Other Organization Name Type Code] [varchar](80) NULL,
    [Provider Other Last Name] [varchar](80) NULL,
    [Provider Other First Name] [varchar](80) NULL,
    [Provider Other Middle Name] [varchar](80) NULL,
    [Provider Other Name Prefix Text] [varchar](80) NULL,
    [Provider Other Name Suffix Text] [varchar](80) NULL,
    [Provider Other Credential Text] [varchar](80) NULL,
    [Provider Other Last Name Type Code] [varchar](80) NULL,
    [Provider First Line Business Mailing Address] [varchar](80) NULL,
    [Provider Second Line Business Mailing Address] [varchar](80) NULL,
    [Provider Business Mailing Address City Name] [varchar](80) NULL,
    [Provider Business Mailing Address State Name] [varchar](80) NULL,
    [Provider Business Mailing Address Postal Code] [varchar](80) NULL,
    [Provider Business Mailing Address Country Code (If outside U S )] [varchar](80) NULL,
    [Provider Business Mailing Address Telephone Number] [varchar](80) NULL,
    [Provider Business Mailing Address Fax Number] [varchar](80) NULL,
    [Provider First Line Business Practice Location Address] [varchar](80) NULL,
    [Provider Second Line Business Practice Location Address] [varchar](80) NULL,
    [Provider Business Practice Location Address City Name] [varchar](80) NULL,
    [Provider Business Practice Location Address State Name] [varchar](80) NULL,
    [Provider Business Practice Location Address Postal Code] [varchar](80) NULL,
    [Provider Business Practice Location Address Country Code (If outside U S )] [varchar](80) NULL,
    [Provider Business Practice Location Address Telephone Number] [varchar](80) NULL,
    [Provider Business Practice Location Address Fax Number] [varchar](80) NULL,
    [Provider Enumeration Date] [varchar](80) NULL,
    [Last Update Date] [varchar](80) NULL,
    [NPI Deactivation Reason Code] [varchar](80) NULL,
    [NPI Deactivation Date] [varchar](80) NULL,
    [NPI Reactivation Date] [varchar](80) NULL,
    [Provider Gender Code] [varchar](80) NULL,
    [Authorized Official Last Name] [varchar](80) NULL,
    [Authorized Official First Name] [varchar](80) NULL,
    [Authorized Official Middle Name] [varchar](80) NULL,
    [Authorized Official Title or Position] [varchar](80) NULL,
    [Authorized Official Telephone Number] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_1] [varchar](80) NULL,
    [Provider License Number_1] [varchar](80) NULL,
    [Provider License Number State Code_1] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_1] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_2] [varchar](80) NULL,
    [Provider License Number_2] [varchar](80) NULL,
    [Provider License Number State Code_2] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_2] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_3] [varchar](80) NULL,
    [Provider License Number_3] [varchar](80) NULL,
    [Provider License Number State Code_3] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_3] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_4] [varchar](80) NULL,
    [Provider License Number_4] [varchar](80) NULL,
    [Provider License Number State Code_4] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_4] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_5] [varchar](80) NULL,
    [Provider License Number_5] [varchar](80) NULL,
    [Provider License Number State Code_5] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_5] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_6] [varchar](80) NULL,
    [Provider License Number_6] [varchar](80) NULL,
    [Provider License Number State Code_6] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_6] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_7] [varchar](80) NULL,
    [Provider License Number_7] [varchar](80) NULL,
    [Provider License Number State Code_7] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_7] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_8] [varchar](80) NULL,
    [Provider License Number_8] [varchar](80) NULL,
    [Provider License Number State Code_8] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_8] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_9] [varchar](80) NULL,
    [Provider License Number_9] [varchar](80) NULL,
    [Provider License Number State Code_9] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_9] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_10] [varchar](80) NULL,
    [Provider License Number_10] [varchar](80) NULL,
    [Provider License Number State Code_10] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_10] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_11] [varchar](80) NULL,
    [Provider License Number_11] [varchar](80) NULL,
    [Provider License Number State Code_11] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_11] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_12] [varchar](80) NULL,
    [Provider License Number_12] [varchar](80) NULL,
    [Provider License Number State Code_12] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_12] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_13] [varchar](80) NULL,
    [Provider License Number_13] [varchar](80) NULL,
    [Provider License Number State Code_13] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_13] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_14] [varchar](80) NULL,
    [Provider License Number_14] [varchar](80) NULL,
    [Provider License Number State Code_14] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_14] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Code_15] [varchar](80) NULL,
    [Provider License Number_15] [varchar](80) NULL,
    [Provider License Number State Code_15] [varchar](80) NULL,
    [Healthcare Provider Primary Taxonomy Switch_15] [varchar](80) NULL,
    [Other Provider Identifier_1] [varchar](80) NULL,
    [Other Provider Identifier Type Code_1] [varchar](80) NULL,
    [Other Provider Identifier State_1] [varchar](80) NULL,
    [Other Provider Identifier Issuer_1] [varchar](80) NULL,
    [Other Provider Identifier_2] [varchar](80) NULL,
    [Other Provider Identifier Type Code_2] [varchar](80) NULL,
    [Other Provider Identifier State_2] [varchar](80) NULL,
    [Other Provider Identifier Issuer_2] [varchar](80) NULL,
    [Other Provider Identifier_3] [varchar](80) NULL,
    [Other Provider Identifier Type Code_3] [varchar](80) NULL,
    [Other Provider Identifier State_3] [varchar](80) NULL,
    [Other Provider Identifier Issuer_3] [varchar](80) NULL,
    [Other Provider Identifier_4] [varchar](80) NULL,
    [Other Provider Identifier Type Code_4] [varchar](80) NULL,
    [Other Provider Identifier State_4] [varchar](80) NULL,
    [Other Provider Identifier Issuer_4] [varchar](80) NULL,
    [Other Provider Identifier_5] [varchar](80) NULL,
    [Other Provider Identifier Type Code_5] [varchar](80) NULL,
    [Other Provider Identifier State_5] [varchar](80) NULL,
    [Other Provider Identifier Issuer_5] [varchar](80) NULL,
    [Other Provider Identifier_6] [varchar](80) NULL,
    [Other Provider Identifier Type Code_6] [varchar](80) NULL,
    [Other Provider Identifier State_6] [varchar](80) NULL,
    [Other Provider Identifier Issuer_6] [varchar](80) NULL,
    [Other Provider Identifier_7] [varchar](80) NULL,
    [Other Provider Identifier Type Code_7] [varchar](80) NULL,
    [Other Provider Identifier State_7] [varchar](80) NULL,
    [Other Provider Identifier Issuer_7] [varchar](80) NULL,
    [Other Provider Identifier_8] [varchar](80) NULL,
    [Other Provider Identifier Type Code_8] [varchar](80) NULL,
    [Other Provider Identifier State_8] [varchar](80) NULL,
    [Other Provider Identifier Issuer_8] [varchar](80) NULL,
    [Other Provider Identifier_9] [varchar](80) NULL,
    [Other Provider Identifier Type Code_9] [varchar](80) NULL,
    [Other Provider Identifier State_9] [varchar](80) NULL,
    [Other Provider Identifier Issuer_9] [varchar](80) NULL,
    [Other Provider Identifier_10] [varchar](80) NULL,
    [Other Provider Identifier Type Code_10] [varchar](80) NULL,
    [Other Provider Identifier State_10] [varchar](80) NULL,
    [Other Provider Identifier Issuer_10] [varchar](80) NULL,
    [Other Provider Identifier_11] [varchar](80) NULL,
    [Other Provider Identifier Type Code_11] [varchar](80) NULL,
    [Other Provider Identifier State_11] [varchar](80) NULL,
    [Other Provider Identifier Issuer_11] [varchar](80) NULL,
    [Other Provider Identifier_12] [varchar](80) NULL,
    [Other Provider Identifier Type Code_12] [varchar](80) NULL,
    [Other Provider Identifier State_12] [varchar](80) NULL,
    [Other Provider Identifier Issuer_12] [varchar](80) NULL,
    [Other Provider Identifier_13] [varchar](80) NULL,
    [Other Provider Identifier Type Code_13] [varchar](80) NULL,
    [Other Provider Identifier State_13] [varchar](80) NULL,
    [Other Provider Identifier Issuer_13] [varchar](80) NULL,
    [Other Provider Identifier_14] [varchar](80) NULL,
    [Other Provider Identifier Type Code_14] [varchar](80) NULL,
    [Other Provider Identifier State_14] [varchar](80) NULL,
    [Other Provider Identifier Issuer_14] [varchar](80) NULL,
    [Other Provider Identifier_15] [varchar](80) NULL,
    [Other Provider Identifier Type Code_15] [varchar](80) NULL,
    [Other Provider Identifier State_15] [varchar](80) NULL,
    [Other Provider Identifier Issuer_15] [varchar](80) NULL,
    [Other Provider Identifier_16] [varchar](80) NULL,
    [Other Provider Identifier Type Code_16] [varchar](80) NULL,
    [Other Provider Identifier State_16] [varchar](80) NULL,
    [Other Provider Identifier Issuer_16] [varchar](80) NULL,
    [Other Provider Identifier_17] [varchar](80) NULL,
    [Other Provider Identifier Type Code_17] [varchar](80) NULL,
    [Other Provider Identifier State_17] [varchar](80) NULL,
    [Other Provider Identifier Issuer_17] [varchar](80) NULL,
    [Other Provider Identifier_18] [varchar](80) NULL,
    [Other Provider Identifier Type Code_18] [varchar](80) NULL,
    [Other Provider Identifier State_18] [varchar](80) NULL,
    [Other Provider Identifier Issuer_18] [varchar](80) NULL,
    [Other Provider Identifier_19] [varchar](80) NULL,
    [Other Provider Identifier Type Code_19] [varchar](80) NULL,
    [Other Provider Identifier State_19] [varchar](80) NULL,
    [Other Provider Identifier Issuer_19] [varchar](80) NULL,
    [Other Provider Identifier_20] [varchar](80) NULL,
    [Other Provider Identifier Type Code_20] [varchar](80) NULL,
    [Other Provider Identifier State_20] [varchar](80) NULL,
    [Other Provider Identifier Issuer_20] [varchar](80) NULL,
    [Other Provider Identifier_21] [varchar](80) NULL,
    [Other Provider Identifier Type Code_21] [varchar](80) NULL,
    [Other Provider Identifier State_21] [varchar](80) NULL,
    [Other Provider Identifier Issuer_21] [varchar](80) NULL,
    [Other Provider Identifier_22] [varchar](80) NULL,
    [Other Provider Identifier Type Code_22] [varchar](80) NULL,
    [Other Provider Identifier State_22] [varchar](80) NULL,
    [Other Provider Identifier Issuer_22] [varchar](80) NULL,
    [Other Provider Identifier_23] [varchar](80) NULL,
    [Other Provider Identifier Type Code_23] [varchar](80) NULL,
    [Other Provider Identifier State_23] [varchar](80) NULL,
    [Other Provider Identifier Issuer_23] [varchar](80) NULL,
    [Other Provider Identifier_24] [varchar](80) NULL,
    [Other Provider Identifier Type Code_24] [varchar](80) NULL,
    [Other Provider Identifier State_24] [varchar](80) NULL,
    [Other Provider Identifier Issuer_24] [varchar](80) NULL,
    [Other Provider Identifier_25] [varchar](80) NULL,
    [Other Provider Identifier Type Code_25] [varchar](80) NULL,
    [Other Provider Identifier State_25] [varchar](80) NULL,
    [Other Provider Identifier Issuer_25] [varchar](80) NULL,
    [Other Provider Identifier_26] [varchar](80) NULL,
    [Other Provider Identifier Type Code_26] [varchar](80) NULL,
    [Other Provider Identifier State_26] [varchar](80) NULL,
    [Other Provider Identifier Issuer_26] [varchar](80) NULL,
    [Other Provider Identifier_27] [varchar](80) NULL,
    [Other Provider Identifier Type Code_27] [varchar](80) NULL,
    [Other Provider Identifier State_27] [varchar](80) NULL,
    [Other Provider Identifier Issuer_27] [varchar](80) NULL,
    [Other Provider Identifier_28] [varchar](80) NULL,
    [Other Provider Identifier Type Code_28] [varchar](80) NULL,
    [Other Provider Identifier State_28] [varchar](80) NULL,
    [Other Provider Identifier Issuer_28] [varchar](80) NULL,
    [Other Provider Identifier_29] [varchar](80) NULL,
    [Other Provider Identifier Type Code_29] [varchar](80) NULL,
    [Other Provider Identifier State_29] [varchar](80) NULL,
    [Other Provider Identifier Issuer_29] [varchar](80) NULL,
    [Other Provider Identifier_30] [varchar](80) NULL,
    [Other Provider Identifier Type Code_30] [varchar](80) NULL,
    [Other Provider Identifier State_30] [varchar](80) NULL,
    [Other Provider Identifier Issuer_30] [varchar](80) NULL,
    [Other Provider Identifier_31] [varchar](80) NULL,
    [Other Provider Identifier Type Code_31] [varchar](80) NULL,
    [Other Provider Identifier State_31] [varchar](80) NULL,
    [Other Provider Identifier Issuer_31] [varchar](80) NULL,
    [Other Provider Identifier_32] [varchar](80) NULL,
    [Other Provider Identifier Type Code_32] [varchar](80) NULL,
    [Other Provider Identifier State_32] [varchar](80) NULL,
    [Other Provider Identifier Issuer_32] [varchar](80) NULL,
    [Other Provider Identifier_33] [varchar](80) NULL,
    [Other Provider Identifier Type Code_33] [varchar](80) NULL,
    [Other Provider Identifier State_33] [varchar](80) NULL,
    [Other Provider Identifier Issuer_33] [varchar](80) NULL,
    [Other Provider Identifier_34] [varchar](80) NULL,
    [Other Provider Identifier Type Code_34] [varchar](80) NULL,
    [Other Provider Identifier State_34] [varchar](80) NULL,
    [Other Provider Identifier Issuer_34] [varchar](80) NULL,
    [Other Provider Identifier_35] [varchar](80) NULL,
    [Other Provider Identifier Type Code_35] [varchar](80) NULL,
    [Other Provider Identifier State_35] [varchar](80) NULL,
    [Other Provider Identifier Issuer_35] [varchar](80) NULL,
    [Other Provider Identifier_36] [varchar](80) NULL,
    [Other Provider Identifier Type Code_36] [varchar](80) NULL,
    [Other Provider Identifier State_36] [varchar](80) NULL,
    [Other Provider Identifier Issuer_36] [varchar](80) NULL,
    [Other Provider Identifier_37] [varchar](80) NULL,
    [Other Provider Identifier Type Code_37] [varchar](80) NULL,
    [Other Provider Identifier State_37] [varchar](80) NULL,
    [Other Provider Identifier Issuer_37] [varchar](80) NULL,
    [Other Provider Identifier_38] [varchar](80) NULL,
    [Other Provider Identifier Type Code_38] [varchar](80) NULL,
    [Other Provider Identifier State_38] [varchar](80) NULL,
    [Other Provider Identifier Issuer_38] [varchar](80) NULL,
    [Other Provider Identifier_39] [varchar](80) NULL,
    [Other Provider Identifier Type Code_39] [varchar](80) NULL,
    [Other Provider Identifier State_39] [varchar](80) NULL,
    [Other Provider Identifier Issuer_39] [varchar](80) NULL,
    [Other Provider Identifier_40] [varchar](80) NULL,
    [Other Provider Identifier Type Code_40] [varchar](80) NULL,
    [Other Provider Identifier State_40] [varchar](80) NULL,
    [Other Provider Identifier Issuer_40] [varchar](80) NULL,
    [Other Provider Identifier_41] [varchar](80) NULL,
    [Other Provider Identifier Type Code_41] [varchar](80) NULL,
    [Other Provider Identifier State_41] [varchar](80) NULL,
    [Other Provider Identifier Issuer_41] [varchar](80) NULL,
    [Other Provider Identifier_42] [varchar](80) NULL,
    [Other Provider Identifier Type Code_42] [varchar](80) NULL,
    [Other Provider Identifier State_42] [varchar](80) NULL,
    [Other Provider Identifier Issuer_42] [varchar](80) NULL,
    [Other Provider Identifier_43] [varchar](80) NULL,
    [Other Provider Identifier Type Code_43] [varchar](80) NULL,
    [Other Provider Identifier State_43] [varchar](80) NULL,
    [Other Provider Identifier Issuer_43] [varchar](80) NULL,
    [Other Provider Identifier_44] [varchar](80) NULL,
    [Other Provider Identifier Type Code_44] [varchar](80) NULL,
    [Other Provider Identifier State_44] [varchar](80) NULL,
    [Other Provider Identifier Issuer_44] [varchar](80) NULL,
    [Other Provider Identifier_45] [varchar](80) NULL,
    [Other Provider Identifier Type Code_45] [varchar](80) NULL,
    [Other Provider Identifier State_45] [varchar](80) NULL,
    [Other Provider Identifier Issuer_45] [varchar](80) NULL,
    [Other Provider Identifier_46] [varchar](80) NULL,
    [Other Provider Identifier Type Code_46] [varchar](80) NULL,
    [Other Provider Identifier State_46] [varchar](80) NULL,
    [Other Provider Identifier Issuer_46] [varchar](80) NULL,
    [Other Provider Identifier_47] [varchar](80) NULL,
    [Other Provider Identifier Type Code_47] [varchar](80) NULL,
    [Other Provider Identifier State_47] [varchar](80) NULL,
    [Other Provider Identifier Issuer_47] [varchar](80) NULL,
    [Other Provider Identifier_48] [varchar](80) NULL,
    [Other Provider Identifier Type Code_48] [varchar](80) NULL,
    [Other Provider Identifier State_48] [varchar](80) NULL,
    [Other Provider Identifier Issuer_48] [varchar](80) NULL,
    [Other Provider Identifier_49] [varchar](80) NULL,
    [Other Provider Identifier Type Code_49] [varchar](80) NULL,
    [Other Provider Identifier State_49] [varchar](80) NULL,
    [Other Provider Identifier Issuer_49] [varchar](80) NULL,
    [Other Provider Identifier_50] [varchar](80) NULL,
    [Other Provider Identifier Type Code_50] [varchar](80) NULL,
    [Other Provider Identifier State_50] [varchar](80) NULL,
    [Other Provider Identifier Issuer_50] [varchar](80) NULL,
    [Is Sole Proprietor] [varchar](80) NULL,
    [Is Organization Subpart] [varchar](80) NULL,
    [Parent Organization LBN] [varchar](80) NULL,
    [Parent Organization TIN] [varchar](80) NULL,
    [Authorized Official Name Prefix Text] [varchar](80) NULL,
    [Authorized Official Name Suffix Text] [varchar](80) NULL,
    [Authorized Official Credential Text] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_1] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_2] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_3] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_4] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_5] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_6] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_7] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_8] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_9] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_10] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_11] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_12] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_13] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_14] [varchar](80) NULL,
    [Healthcare Provider Taxonomy Group_15] [varchar](80) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

I know for sure that there's no column bigger than 80 characters. I've also tried to change it to 500 characters and still getting the same error.

What am I doing wrong?

Why can I not import this file?

Here is a sample of one of the rows:
"139236748349","1","","","","GRUrt3NERT","GEORGE","M","DR.","","M.D.","","","","","","","","","","7234900 FANNIN ST","SUITE 4423400","HOUSTON","TX","770523442900","US","713334351227000","713g25127082","792300 FANNIN ST","SUITE 423400","HOUSTON","TX","7705ef242900","US","7132225127000","713512ff27082","05/23/2005","01/22/2009","","","","M","","","","","","207VE0f2f102X","E02f945","TX","Y","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","82f4380J","04","TX","FT.BEND/MONT","B2f33159","02","TX","","8432335J","04","TX","BRAZORIA","8dd2047G","01","TX","BLUE CROSS & BLUE SHIELD","84sd2282J","04","TX","HARRIS COUNTY","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","N","","","","","","","","","","","","","","","","","","","","",""

Just an update... I changed all the fields to nvarchar(max)

and still getting this horrible error:

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)
    Messages
    * Warning 0x80049304: Data Flow Task 1: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To resolve, run this package as an administrator, or on the system's console.
     (SQL Server Import and Export Wizard)


- Prepare for Execute (Success)

- Pre-execute (Success)
    Messages
    * Information 0x402090dc: Data Flow Task 1: The processing of file "S:\tmp\nppes\npidata_20050523-20111114.csv" has started.
     (SQL Server Import and Export Wizard)


- Executing (Error)
    Messages
    * Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Other Provider Identifier Issuer_5" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
     (SQL Server Import and Export Wizard)

    * Error 0xc020902a: Data Flow Task 1: The "output column "Other Provider Identifier Issuer_5" (514)" failed because truncation occurred, and the truncation row disposition on "output column "Other Provider Identifier Issuer_5" (514)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
     (SQL Server Import and Export Wizard)

    * Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "S:\tmp\nppes\npidata_20050523-20111114.csv" on data row 79.
     (SQL Server Import and Export Wizard)

    * Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - npidata_20050523-20111114_csv" (1) returned error code 0xC0202092.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
     (SQL Server Import and Export Wizard)


- Copying to [dbo].[npidata_20050523-20111114] (Stopped)

- Post-execute (Success)
    Messages
    * Information 0x402090dd: Data Flow Task 1: The processing of file "S:\tmp\nppes\npidata_20050523-20111114.csv" has ended.
     (SQL Server Import and Export Wizard)

    * Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - npidata_20050523-20111114" (1326)" has started.
     (SQL Server Import and Export Wizard)

    * Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion  in "component "Destination - npidata_20050523-20111114" (1326)" has ended.
     (SQL Server Import and Export Wizard)

    * Information 0x4004300b: Data Flow Task 1: "component "Destination - npidata_20050523-20111114" (1326)" wrote 58 rows.
     (SQL Server Import and Export Wizard)

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（5）

隐诗 2024-12-30 16:19:02

我将通过外部脚本验证导致错误的行 - 比如一些快速的 powershell。例如

$data = @(Import-Csv .\partialFile.csv )
$row = $data[0]

# how many columns do we have?
$row | gm -membertype NoteProperty | Measure-Object 

# columns larger than 80 chars
$row | gm -membertype NoteProperty | ? { ($row."$($_.Name)").Length -gt 80 }

I would validate the rows causing errors through an external script - say some quick powershell. For instance

$data = @(Import-Csv .\partialFile.csv )
$row = $data[0]

# how many columns do we have?
$row | gm -membertype NoteProperty | Measure-Object 

# columns larger than 80 chars
$row | gm -membertype NoteProperty | ? { ($row."$($_.Name)").Length -gt 80 }
回复 原文
与风相奔跑 2024-12-30 16:19:02

我看到您使用了导入向导（它构建了一个 SSIS 包）。

您可以尝试使用 SSIS 加载此文件：

  • 创建数据流任务
  • 创建平面文件源，指向 csv。按照您配置的设置参数。
  • 设置错误输出以在截断时重定向行 在
  • 错误输出上添加数据读取器目标，在数据读取器的路径上附加数据查看器。
  • 将常规输出发送到另一个数据读取器
  • 运行包

您现在应该看到是否有任何行因某种原因 SSIS（导入）“认为”超过 80 个字符。然后您应该能够很快识别出错误。

另外，如果 csv 文件中有 329 列，请检查您的行终止符？

I see you used the Import wizard (which builds an SSIS package).

You could try to load this file using SSIS:

  • Make a dataflow task
  • Make a flat file source, point to csv. set parameters as you have configured.
  • Set error output to redirect rows on truncation
  • Add a datareader destination on the error output, attach a data viewer on the path to the data reader.
  • Send the regular output to another data reader
  • Run the package

You should now see if there's any rows that SSIS (import) "thinks" is more than 80 characters for some reason. You should quickly be able to identify the error(s) then.

Also, in case there are 329 columns in the csv file, check your line terminator?

回复 原文
末骤雨初歇 2024-12-30 16:19:02

根据您的表 DDL，您可能会达到 SQL 中的最大行大小 8060。请此处查看最大规格。

相反，我会尝试尽可能减小字段的大小。

Based on your table DDL, it is likely that you are hitting the max row size of 8060 in SQL. Check out the max specs here.

I would, instead, try to decrease the size of the fields where possible.

回复 原文
风启觞 2024-12-30 16:19:02

使用以下 DDL 创建一个表：

USE [YOUR_DATABASE]
GO

/****** Object:  Table [dbo].[YOUR_TABLE]    Script Date: 02/21/2012 14:07:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[NPI_RAW](
    [NPI] [varchar](50) NULL,
    [Entity Type Code] [varchar](50) NULL,
    [Replacement NPI] [varchar](50) NULL,
    [Employer Identification Number (EIN)] [varchar](50) NULL,
    [Provider Organization Name (Legal Business Name)] [varchar](50) NULL,
    [Provider Last Name (Legal Name)] [varchar](50) NULL,
    [Provider First Name] [varchar](50) NULL,
    [Provider Middle Name] [varchar](50) NULL,
    [Provider Name Prefix Text] [varchar](50) NULL,
    [Provider Name Suffix Text] [varchar](50) NULL,
    [Provider Credential Text] [varchar](50) NULL,
    [Provider Other Organization Name] [varchar](50) NULL,
    [Provider Other Organization Name Type Code] [varchar](50) NULL,
    [Provider Other Last Name] [varchar](50) NULL,
    [Provider Other First Name] [varchar](50) NULL,
    [Provider Other Middle Name] [varchar](50) NULL,
    [Provider Other Name Prefix Text] [varchar](50) NULL,
    [Provider Other Name Suffix Text] [varchar](50) NULL,
    [Provider Other Credential Text] [varchar](50) NULL,
    [Provider Other Last Name Type Code] [varchar](50) NULL,
    [Provider First Line Business Mailing Address] [varchar](50) NULL,
    [Provider Second Line Business Mailing Address] [varchar](50) NULL,
    [Provider Business Mailing Address City Name] [varchar](50) NULL,
    [Provider Business Mailing Address State Name] [varchar](50) NULL,
    [Provider Business Mailing Address Postal Code] [varchar](50) NULL,
    [Provider Business Mailing Address Country Code (If outside U S )] [varchar](50) NULL,
    [Provider Business Mailing Address Telephone Number] [varchar](50) NULL,
    [Provider Business Mailing Address Fax Number] [varchar](50) NULL,
    [Provider First Line Business Practice Location Address] [varchar](50) NULL,
    [Provider Second Line Business Practice Location Address] [varchar](50) NULL,
    [Provider Business Practice Location Address City Name] [varchar](50) NULL,
    [Provider Business Practice Location Address State Name] [varchar](50) NULL,
    [Provider Business Practice Location Address Postal Code] [varchar](50) NULL,
    [Provider Business Practice Location Address Country Code (If outside U S )] [varchar](50) NULL,
    [Provider Business Practice Location Address Telephone Number] [varchar](50) NULL,
    [Provider Business Practice Location Address Fax Number] [varchar](50) NULL,
    [Provider Enumeration Date] [varchar](50) NULL,
    [Last Update Date] [varchar](50) NULL,
    [NPI Deactivation Reason Code] [varchar](50) NULL,
    [NPI Deactivation Date] [varchar](50) NULL,
    [NPI Reactivation Date] [varchar](50) NULL,
    [Provider Gender Code] [varchar](50) NULL,
    [Authorized Official Last Name] [varchar](50) NULL,
    [Authorized Official First Name] [varchar](50) NULL,
    [Authorized Official Middle Name] [varchar](50) NULL,
    [Authorized Official Title or Position] [varchar](50) NULL,
    [Authorized Official Telephone Number] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_1] [varchar](50) NULL,
    [Provider License Number_1] [varchar](50) NULL,
    [Provider License Number State Code_1] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_1] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_2] [varchar](50) NULL,
    [Provider License Number_2] [varchar](50) NULL,
    [Provider License Number State Code_2] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_2] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_3] [varchar](50) NULL,
    [Provider License Number_3] [varchar](50) NULL,
    [Provider License Number State Code_3] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_3] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_4] [varchar](50) NULL,
    [Provider License Number_4] [varchar](50) NULL,
    [Provider License Number State Code_4] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_4] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_5] [varchar](50) NULL,
    [Provider License Number_5] [varchar](50) NULL,
    [Provider License Number State Code_5] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_5] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_6] [varchar](50) NULL,
    [Provider License Number_6] [varchar](50) NULL,
    [Provider License Number State Code_6] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_6] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_7] [varchar](50) NULL,
    [Provider License Number_7] [varchar](50) NULL,
    [Provider License Number State Code_7] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_7] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_8] [varchar](50) NULL,
    [Provider License Number_8] [varchar](50) NULL,
    [Provider License Number State Code_8] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_8] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_9] [varchar](50) NULL,
    [Provider License Number_9] [varchar](50) NULL,
    [Provider License Number State Code_9] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_9] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_10] [varchar](50) NULL,
    [Provider License Number_10] [varchar](50) NULL,
    [Provider License Number State Code_10] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_10] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_11] [varchar](50) NULL,
    [Provider License Number_11] [varchar](50) NULL,
    [Provider License Number State Code_11] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_11] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_12] [varchar](50) NULL,
    [Provider License Number_12] [varchar](50) NULL,
    [Provider License Number State Code_12] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_12] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_13] [varchar](50) NULL,
    [Provider License Number_13] [varchar](50) NULL,
    [Provider License Number State Code_13] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_13] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_14] [varchar](50) NULL,
    [Provider License Number_14] [varchar](50) NULL,
    [Provider License Number State Code_14] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_14] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_15] [varchar](50) NULL,
    [Provider License Number_15] [varchar](50) NULL,
    [Provider License Number State Code_15] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_15] [varchar](50) NULL,
    [Other Provider Identifier_1] [varchar](50) NULL,
    [Other Provider Identifier Type Code_1] [varchar](50) NULL,
    [Other Provider Identifier State_1] [varchar](50) NULL,
    [Other Provider Identifier Issuer_1] [varchar](50) NULL,
    [Other Provider Identifier_2] [varchar](50) NULL,
    [Other Provider Identifier Type Code_2] [varchar](50) NULL,
    [Other Provider Identifier State_2] [varchar](50) NULL,
    [Other Provider Identifier Issuer_2] [varchar](50) NULL,
    [Other Provider Identifier_3] [varchar](50) NULL,
    [Other Provider Identifier Type Code_3] [varchar](50) NULL,
    [Other Provider Identifier State_3] [varchar](50) NULL,
    [Other Provider Identifier Issuer_3] [varchar](50) NULL,
    [Other Provider Identifier_4] [varchar](50) NULL,
    [Other Provider Identifier Type Code_4] [varchar](50) NULL,
    [Other Provider Identifier State_4] [varchar](50) NULL,
    [Other Provider Identifier Issuer_4] [varchar](50) NULL,
    [Other Provider Identifier_5] [varchar](50) NULL,
    [Other Provider Identifier Type Code_5] [varchar](50) NULL,
    [Other Provider Identifier State_5] [varchar](50) NULL,
    [Other Provider Identifier Issuer_5] [varchar](50) NULL,
    [Other Provider Identifier_6] [varchar](50) NULL,
    [Other Provider Identifier Type Code_6] [varchar](50) NULL,
    [Other Provider Identifier State_6] [varchar](50) NULL,
    [Other Provider Identifier Issuer_6] [varchar](50) NULL,
    [Other Provider Identifier_7] [varchar](50) NULL,
    [Other Provider Identifier Type Code_7] [varchar](50) NULL,
    [Other Provider Identifier State_7] [varchar](50) NULL,
    [Other Provider Identifier Issuer_7] [varchar](50) NULL,
    [Other Provider Identifier_8] [varchar](50) NULL,
    [Other Provider Identifier Type Code_8] [varchar](50) NULL,
    [Other Provider Identifier State_8] [varchar](50) NULL,
    [Other Provider Identifier Issuer_8] [varchar](50) NULL,
    [Other Provider Identifier_9] [varchar](50) NULL,
    [Other Provider Identifier Type Code_9] [varchar](50) NULL,
    [Other Provider Identifier State_9] [varchar](50) NULL,
    [Other Provider Identifier Issuer_9] [varchar](50) NULL,
    [Other Provider Identifier_10] [varchar](50) NULL,
    [Other Provider Identifier Type Code_10] [varchar](50) NULL,
    [Other Provider Identifier State_10] [varchar](50) NULL,
    [Other Provider Identifier Issuer_10] [varchar](50) NULL,
    [Other Provider Identifier_11] [varchar](50) NULL,
    [Other Provider Identifier Type Code_11] [varchar](50) NULL,
    [Other Provider Identifier State_11] [varchar](50) NULL,
    [Other Provider Identifier Issuer_11] [varchar](50) NULL,
    [Other Provider Identifier_12] [varchar](50) NULL,
    [Other Provider Identifier Type Code_12] [varchar](50) NULL,
    [Other Provider Identifier State_12] [varchar](50) NULL,
    [Other Provider Identifier Issuer_12] [varchar](50) NULL,
    [Other Provider Identifier_13] [varchar](50) NULL,
    [Other Provider Identifier Type Code_13] [varchar](50) NULL,
    [Other Provider Identifier State_13] [varchar](50) NULL,
    [Other Provider Identifier Issuer_13] [varchar](50) NULL,
    [Other Provider Identifier_14] [varchar](50) NULL,
    [Other Provider Identifier Type Code_14] [varchar](50) NULL,
    [Other Provider Identifier State_14] [varchar](50) NULL,
    [Other Provider Identifier Issuer_14] [varchar](50) NULL,
    [Other Provider Identifier_15] [varchar](50) NULL,
    [Other Provider Identifier Type Code_15] [varchar](50) NULL,
    [Other Provider Identifier State_15] [varchar](50) NULL,
    [Other Provider Identifier Issuer_15] [varchar](50) NULL,
    [Other Provider Identifier_16] [varchar](50) NULL,
    [Other Provider Identifier Type Code_16] [varchar](50) NULL,
    [Other Provider Identifier State_16] [varchar](50) NULL,
    [Other Provider Identifier Issuer_16] [varchar](50) NULL,
    [Other Provider Identifier_17] [varchar](50) NULL,
    [Other Provider Identifier Type Code_17] [varchar](50) NULL,
    [Other Provider Identifier State_17] [varchar](50) NULL,
    [Other Provider Identifier Issuer_17] [varchar](50) NULL,
    [Other Provider Identifier_18] [varchar](50) NULL,
    [Other Provider Identifier Type Code_18] [varchar](50) NULL,
    [Other Provider Identifier State_18] [varchar](50) NULL,
    [Other Provider Identifier Issuer_18] [varchar](50) NULL,
    [Other Provider Identifier_19] [varchar](50) NULL,
    [Other Provider Identifier Type Code_19] [varchar](50) NULL,
    [Other Provider Identifier State_19] [varchar](50) NULL,
    [Other Provider Identifier Issuer_19] [varchar](50) NULL,
    [Other Provider Identifier_20] [varchar](50) NULL,
    [Other Provider Identifier Type Code_20] [varchar](50) NULL,
    [Other Provider Identifier State_20] [varchar](50) NULL,
    [Other Provider Identifier Issuer_20] [varchar](50) NULL,
    [Other Provider Identifier_21] [varchar](50) NULL,
    [Other Provider Identifier Type Code_21] [varchar](50) NULL,
    [Other Provider Identifier State_21] [varchar](50) NULL,
    [Other Provider Identifier Issuer_21] [varchar](50) NULL,
    [Other Provider Identifier_22] [varchar](50) NULL,
    [Other Provider Identifier Type Code_22] [varchar](50) NULL,
    [Other Provider Identifier State_22] [varchar](50) NULL,
    [Other Provider Identifier Issuer_22] [varchar](50) NULL,
    [Other Provider Identifier_23] [varchar](50) NULL,
    [Other Provider Identifier Type Code_23] [varchar](50) NULL,
    [Other Provider Identifier State_23] [varchar](50) NULL,
    [Other Provider Identifier Issuer_23] [varchar](50) NULL,
    [Other Provider Identifier_24] [varchar](50) NULL,
    [Other Provider Identifier Type Code_24] [varchar](50) NULL,
    [Other Provider Identifier State_24] [varchar](50) NULL,
    [Other Provider Identifier Issuer_24] [varchar](50) NULL,
    [Other Provider Identifier_25] [varchar](50) NULL,
    [Other Provider Identifier Type Code_25] [varchar](50) NULL,
    [Other Provider Identifier State_25] [varchar](50) NULL,
    [Other Provider Identifier Issuer_25] [varchar](50) NULL,
    [Other Provider Identifier_26] [varchar](50) NULL,
    [Other Provider Identifier Type Code_26] [varchar](50) NULL,
    [Other Provider Identifier State_26] [varchar](50) NULL,
    [Other Provider Identifier Issuer_26] [varchar](50) NULL,
    [Other Provider Identifier_27] [varchar](50) NULL,
    [Other Provider Identifier Type Code_27] [varchar](50) NULL,
    [Other Provider Identifier State_27] [varchar](50) NULL,
    [Other Provider Identifier Issuer_27] [varchar](50) NULL,
    [Other Provider Identifier_28] [varchar](50) NULL,
    [Other Provider Identifier Type Code_28] [varchar](50) NULL,
    [Other Provider Identifier State_28] [varchar](50) NULL,
    [Other Provider Identifier Issuer_28] [varchar](50) NULL,
    [Other Provider Identifier_29] [varchar](50) NULL,
    [Other Provider Identifier Type Code_29] [varchar](50) NULL,
    [Other Provider Identifier State_29] [varchar](50) NULL,
    [Other Provider Identifier Issuer_29] [varchar](50) NULL,
    [Other Provider Identifier_30] [varchar](50) NULL,
    [Other Provider Identifier Type Code_30] [varchar](50) NULL,
    [Other Provider Identifier State_30] [varchar](50) NULL,
    [Other Provider Identifier Issuer_30] [varchar](50) NULL,
    [Other Provider Identifier_31] [varchar](50) NULL,
    [Other Provider Identifier Type Code_31] [varchar](50) NULL,
    [Other Provider Identifier State_31] [varchar](50) NULL,
    [Other Provider Identifier Issuer_31] [varchar](50) NULL,
    [Other Provider Identifier_32] [varchar](50) NULL,
    [Other Provider Identifier Type Code_32] [varchar](50) NULL,
    [Other Provider Identifier State_32] [varchar](50) NULL,
    [Other Provider Identifier Issuer_32] [varchar](50) NULL,
    [Other Provider Identifier_33] [varchar](50) NULL,
    [Other Provider Identifier Type Code_33] [varchar](50) NULL,
    [Other Provider Identifier State_33] [varchar](50) NULL,
    [Other Provider Identifier Issuer_33] [varchar](50) NULL,
    [Other Provider Identifier_34] [varchar](50) NULL,
    [Other Provider Identifier Type Code_34] [varchar](50) NULL,
    [Other Provider Identifier State_34] [varchar](50) NULL,
    [Other Provider Identifier Issuer_34] [varchar](50) NULL,
    [Other Provider Identifier_35] [varchar](50) NULL,
    [Other Provider Identifier Type Code_35] [varchar](50) NULL,
    [Other Provider Identifier State_35] [varchar](50) NULL,
    [Other Provider Identifier Issuer_35] [varchar](50) NULL,
    [Other Provider Identifier_36] [varchar](50) NULL,
    [Other Provider Identifier Type Code_36] [varchar](50) NULL,
    [Other Provider Identifier State_36] [varchar](50) NULL,
    [Other Provider Identifier Issuer_36] [varchar](50) NULL,
    [Other Provider Identifier_37] [varchar](50) NULL,
    [Other Provider Identifier Type Code_37] [varchar](50) NULL,
    [Other Provider Identifier State_37] [varchar](50) NULL,
    [Other Provider Identifier Issuer_37] [varchar](50) NULL,
    [Other Provider Identifier_38] [varchar](50) NULL,
    [Other Provider Identifier Type Code_38] [varchar](50) NULL,
    [Other Provider Identifier State_38] [varchar](50) NULL,
    [Other Provider Identifier Issuer_38] [varchar](50) NULL,
    [Other Provider Identifier_39] [varchar](50) NULL,
    [Other Provider Identifier Type Code_39] [varchar](50) NULL,
    [Other Provider Identifier State_39] [varchar](50) NULL,
    [Other Provider Identifier Issuer_39] [varchar](50) NULL,
    [Other Provider Identifier_40] [varchar](50) NULL,
    [Other Provider Identifier Type Code_40] [varchar](50) NULL,
    [Other Provider Identifier State_40] [varchar](50) NULL,
    [Other Provider Identifier Issuer_40] [varchar](50) NULL,
    [Other Provider Identifier_41] [varchar](50) NULL,
    [Other Provider Identifier Type Code_41] [varchar](50) NULL,
    [Other Provider Identifier State_41] [varchar](50) NULL,
    [Other Provider Identifier Issuer_41] [varchar](50) NULL,
    [Other Provider Identifier_42] [varchar](50) NULL,
    [Other Provider Identifier Type Code_42] [varchar](50) NULL,
    [Other Provider Identifier State_42] [varchar](50) NULL,
    [Other Provider Identifier Issuer_42] [varchar](50) NULL,
    [Other Provider Identifier_43] [varchar](50) NULL,
    [Other Provider Identifier Type Code_43] [varchar](50) NULL,
    [Other Provider Identifier State_43] [varchar](50) NULL,
    [Other Provider Identifier Issuer_43] [varchar](50) NULL,
    [Other Provider Identifier_44] [varchar](50) NULL,
    [Other Provider Identifier Type Code_44] [varchar](50) NULL,
    [Other Provider Identifier State_44] [varchar](50) NULL,
    [Other Provider Identifier Issuer_44] [varchar](50) NULL,
    [Other Provider Identifier_45] [varchar](50) NULL,
    [Other Provider Identifier Type Code_45] [varchar](50) NULL,
    [Other Provider Identifier State_45] [varchar](50) NULL,
    [Other Provider Identifier Issuer_45] [varchar](50) NULL,
    [Other Provider Identifier_46] [varchar](50) NULL,
    [Other Provider Identifier Type Code_46] [varchar](50) NULL,
    [Other Provider Identifier State_46] [varchar](50) NULL,
    [Other Provider Identifier Issuer_46] [varchar](50) NULL,
    [Other Provider Identifier_47] [varchar](50) NULL,
    [Other Provider Identifier Type Code_47] [varchar](50) NULL,
    [Other Provider Identifier State_47] [varchar](50) NULL,
    [Other Provider Identifier Issuer_47] [varchar](50) NULL,
    [Other Provider Identifier_48] [varchar](50) NULL,
    [Other Provider Identifier Type Code_48] [varchar](50) NULL,
    [Other Provider Identifier State_48] [varchar](50) NULL,
    [Other Provider Identifier Issuer_48] [varchar](50) NULL,
    [Other Provider Identifier_49] [varchar](50) NULL,
    [Other Provider Identifier Type Code_49] [varchar](50) NULL,
    [Other Provider Identifier State_49] [varchar](50) NULL,
    [Other Provider Identifier Issuer_49] [varchar](50) NULL,
    [Other Provider Identifier_50] [varchar](50) NULL,
    [Other Provider Identifier Type Code_50] [varchar](50) NULL,
    [Other Provider Identifier State_50] [varchar](50) NULL,
    [Other Provider Identifier Issuer_50] [varchar](50) NULL,
    [Is Sole Proprietor] [varchar](50) NULL,
    [Is Organization Subpart] [varchar](50) NULL,
    [Parent Organization LBN] [varchar](50) NULL,
    [Parent Organization TIN] [varchar](50) NULL,
    [Authorized Official Name Prefix Text] [varchar](50) NULL,
    [Authorized Official Name Suffix Text] [varchar](50) NULL,
    [Authorized Official Credential Text] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_1] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_2] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_3] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_4] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_5] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_6] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_7] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_8] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_9] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_10] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_11] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_12] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_13] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_14] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_15] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

使该表成为 SSIS 中数据流的输出。

祝你好运！当我每月根据 NPPES .CSV 的导入更新自己的 SQL-Server (2008) 目标表时，这应该可以工作。

Create a table with the following DDL:

USE [YOUR_DATABASE]
GO

/****** Object:  Table [dbo].[YOUR_TABLE]    Script Date: 02/21/2012 14:07:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[NPI_RAW](
    [NPI] [varchar](50) NULL,
    [Entity Type Code] [varchar](50) NULL,
    [Replacement NPI] [varchar](50) NULL,
    [Employer Identification Number (EIN)] [varchar](50) NULL,
    [Provider Organization Name (Legal Business Name)] [varchar](50) NULL,
    [Provider Last Name (Legal Name)] [varchar](50) NULL,
    [Provider First Name] [varchar](50) NULL,
    [Provider Middle Name] [varchar](50) NULL,
    [Provider Name Prefix Text] [varchar](50) NULL,
    [Provider Name Suffix Text] [varchar](50) NULL,
    [Provider Credential Text] [varchar](50) NULL,
    [Provider Other Organization Name] [varchar](50) NULL,
    [Provider Other Organization Name Type Code] [varchar](50) NULL,
    [Provider Other Last Name] [varchar](50) NULL,
    [Provider Other First Name] [varchar](50) NULL,
    [Provider Other Middle Name] [varchar](50) NULL,
    [Provider Other Name Prefix Text] [varchar](50) NULL,
    [Provider Other Name Suffix Text] [varchar](50) NULL,
    [Provider Other Credential Text] [varchar](50) NULL,
    [Provider Other Last Name Type Code] [varchar](50) NULL,
    [Provider First Line Business Mailing Address] [varchar](50) NULL,
    [Provider Second Line Business Mailing Address] [varchar](50) NULL,
    [Provider Business Mailing Address City Name] [varchar](50) NULL,
    [Provider Business Mailing Address State Name] [varchar](50) NULL,
    [Provider Business Mailing Address Postal Code] [varchar](50) NULL,
    [Provider Business Mailing Address Country Code (If outside U S )] [varchar](50) NULL,
    [Provider Business Mailing Address Telephone Number] [varchar](50) NULL,
    [Provider Business Mailing Address Fax Number] [varchar](50) NULL,
    [Provider First Line Business Practice Location Address] [varchar](50) NULL,
    [Provider Second Line Business Practice Location Address] [varchar](50) NULL,
    [Provider Business Practice Location Address City Name] [varchar](50) NULL,
    [Provider Business Practice Location Address State Name] [varchar](50) NULL,
    [Provider Business Practice Location Address Postal Code] [varchar](50) NULL,
    [Provider Business Practice Location Address Country Code (If outside U S )] [varchar](50) NULL,
    [Provider Business Practice Location Address Telephone Number] [varchar](50) NULL,
    [Provider Business Practice Location Address Fax Number] [varchar](50) NULL,
    [Provider Enumeration Date] [varchar](50) NULL,
    [Last Update Date] [varchar](50) NULL,
    [NPI Deactivation Reason Code] [varchar](50) NULL,
    [NPI Deactivation Date] [varchar](50) NULL,
    [NPI Reactivation Date] [varchar](50) NULL,
    [Provider Gender Code] [varchar](50) NULL,
    [Authorized Official Last Name] [varchar](50) NULL,
    [Authorized Official First Name] [varchar](50) NULL,
    [Authorized Official Middle Name] [varchar](50) NULL,
    [Authorized Official Title or Position] [varchar](50) NULL,
    [Authorized Official Telephone Number] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_1] [varchar](50) NULL,
    [Provider License Number_1] [varchar](50) NULL,
    [Provider License Number State Code_1] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_1] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_2] [varchar](50) NULL,
    [Provider License Number_2] [varchar](50) NULL,
    [Provider License Number State Code_2] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_2] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_3] [varchar](50) NULL,
    [Provider License Number_3] [varchar](50) NULL,
    [Provider License Number State Code_3] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_3] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_4] [varchar](50) NULL,
    [Provider License Number_4] [varchar](50) NULL,
    [Provider License Number State Code_4] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_4] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_5] [varchar](50) NULL,
    [Provider License Number_5] [varchar](50) NULL,
    [Provider License Number State Code_5] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_5] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_6] [varchar](50) NULL,
    [Provider License Number_6] [varchar](50) NULL,
    [Provider License Number State Code_6] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_6] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_7] [varchar](50) NULL,
    [Provider License Number_7] [varchar](50) NULL,
    [Provider License Number State Code_7] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_7] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_8] [varchar](50) NULL,
    [Provider License Number_8] [varchar](50) NULL,
    [Provider License Number State Code_8] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_8] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_9] [varchar](50) NULL,
    [Provider License Number_9] [varchar](50) NULL,
    [Provider License Number State Code_9] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_9] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_10] [varchar](50) NULL,
    [Provider License Number_10] [varchar](50) NULL,
    [Provider License Number State Code_10] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_10] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_11] [varchar](50) NULL,
    [Provider License Number_11] [varchar](50) NULL,
    [Provider License Number State Code_11] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_11] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_12] [varchar](50) NULL,
    [Provider License Number_12] [varchar](50) NULL,
    [Provider License Number State Code_12] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_12] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_13] [varchar](50) NULL,
    [Provider License Number_13] [varchar](50) NULL,
    [Provider License Number State Code_13] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_13] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_14] [varchar](50) NULL,
    [Provider License Number_14] [varchar](50) NULL,
    [Provider License Number State Code_14] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_14] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Code_15] [varchar](50) NULL,
    [Provider License Number_15] [varchar](50) NULL,
    [Provider License Number State Code_15] [varchar](50) NULL,
    [Healthcare Provider Primary Taxonomy Switch_15] [varchar](50) NULL,
    [Other Provider Identifier_1] [varchar](50) NULL,
    [Other Provider Identifier Type Code_1] [varchar](50) NULL,
    [Other Provider Identifier State_1] [varchar](50) NULL,
    [Other Provider Identifier Issuer_1] [varchar](50) NULL,
    [Other Provider Identifier_2] [varchar](50) NULL,
    [Other Provider Identifier Type Code_2] [varchar](50) NULL,
    [Other Provider Identifier State_2] [varchar](50) NULL,
    [Other Provider Identifier Issuer_2] [varchar](50) NULL,
    [Other Provider Identifier_3] [varchar](50) NULL,
    [Other Provider Identifier Type Code_3] [varchar](50) NULL,
    [Other Provider Identifier State_3] [varchar](50) NULL,
    [Other Provider Identifier Issuer_3] [varchar](50) NULL,
    [Other Provider Identifier_4] [varchar](50) NULL,
    [Other Provider Identifier Type Code_4] [varchar](50) NULL,
    [Other Provider Identifier State_4] [varchar](50) NULL,
    [Other Provider Identifier Issuer_4] [varchar](50) NULL,
    [Other Provider Identifier_5] [varchar](50) NULL,
    [Other Provider Identifier Type Code_5] [varchar](50) NULL,
    [Other Provider Identifier State_5] [varchar](50) NULL,
    [Other Provider Identifier Issuer_5] [varchar](50) NULL,
    [Other Provider Identifier_6] [varchar](50) NULL,
    [Other Provider Identifier Type Code_6] [varchar](50) NULL,
    [Other Provider Identifier State_6] [varchar](50) NULL,
    [Other Provider Identifier Issuer_6] [varchar](50) NULL,
    [Other Provider Identifier_7] [varchar](50) NULL,
    [Other Provider Identifier Type Code_7] [varchar](50) NULL,
    [Other Provider Identifier State_7] [varchar](50) NULL,
    [Other Provider Identifier Issuer_7] [varchar](50) NULL,
    [Other Provider Identifier_8] [varchar](50) NULL,
    [Other Provider Identifier Type Code_8] [varchar](50) NULL,
    [Other Provider Identifier State_8] [varchar](50) NULL,
    [Other Provider Identifier Issuer_8] [varchar](50) NULL,
    [Other Provider Identifier_9] [varchar](50) NULL,
    [Other Provider Identifier Type Code_9] [varchar](50) NULL,
    [Other Provider Identifier State_9] [varchar](50) NULL,
    [Other Provider Identifier Issuer_9] [varchar](50) NULL,
    [Other Provider Identifier_10] [varchar](50) NULL,
    [Other Provider Identifier Type Code_10] [varchar](50) NULL,
    [Other Provider Identifier State_10] [varchar](50) NULL,
    [Other Provider Identifier Issuer_10] [varchar](50) NULL,
    [Other Provider Identifier_11] [varchar](50) NULL,
    [Other Provider Identifier Type Code_11] [varchar](50) NULL,
    [Other Provider Identifier State_11] [varchar](50) NULL,
    [Other Provider Identifier Issuer_11] [varchar](50) NULL,
    [Other Provider Identifier_12] [varchar](50) NULL,
    [Other Provider Identifier Type Code_12] [varchar](50) NULL,
    [Other Provider Identifier State_12] [varchar](50) NULL,
    [Other Provider Identifier Issuer_12] [varchar](50) NULL,
    [Other Provider Identifier_13] [varchar](50) NULL,
    [Other Provider Identifier Type Code_13] [varchar](50) NULL,
    [Other Provider Identifier State_13] [varchar](50) NULL,
    [Other Provider Identifier Issuer_13] [varchar](50) NULL,
    [Other Provider Identifier_14] [varchar](50) NULL,
    [Other Provider Identifier Type Code_14] [varchar](50) NULL,
    [Other Provider Identifier State_14] [varchar](50) NULL,
    [Other Provider Identifier Issuer_14] [varchar](50) NULL,
    [Other Provider Identifier_15] [varchar](50) NULL,
    [Other Provider Identifier Type Code_15] [varchar](50) NULL,
    [Other Provider Identifier State_15] [varchar](50) NULL,
    [Other Provider Identifier Issuer_15] [varchar](50) NULL,
    [Other Provider Identifier_16] [varchar](50) NULL,
    [Other Provider Identifier Type Code_16] [varchar](50) NULL,
    [Other Provider Identifier State_16] [varchar](50) NULL,
    [Other Provider Identifier Issuer_16] [varchar](50) NULL,
    [Other Provider Identifier_17] [varchar](50) NULL,
    [Other Provider Identifier Type Code_17] [varchar](50) NULL,
    [Other Provider Identifier State_17] [varchar](50) NULL,
    [Other Provider Identifier Issuer_17] [varchar](50) NULL,
    [Other Provider Identifier_18] [varchar](50) NULL,
    [Other Provider Identifier Type Code_18] [varchar](50) NULL,
    [Other Provider Identifier State_18] [varchar](50) NULL,
    [Other Provider Identifier Issuer_18] [varchar](50) NULL,
    [Other Provider Identifier_19] [varchar](50) NULL,
    [Other Provider Identifier Type Code_19] [varchar](50) NULL,
    [Other Provider Identifier State_19] [varchar](50) NULL,
    [Other Provider Identifier Issuer_19] [varchar](50) NULL,
    [Other Provider Identifier_20] [varchar](50) NULL,
    [Other Provider Identifier Type Code_20] [varchar](50) NULL,
    [Other Provider Identifier State_20] [varchar](50) NULL,
    [Other Provider Identifier Issuer_20] [varchar](50) NULL,
    [Other Provider Identifier_21] [varchar](50) NULL,
    [Other Provider Identifier Type Code_21] [varchar](50) NULL,
    [Other Provider Identifier State_21] [varchar](50) NULL,
    [Other Provider Identifier Issuer_21] [varchar](50) NULL,
    [Other Provider Identifier_22] [varchar](50) NULL,
    [Other Provider Identifier Type Code_22] [varchar](50) NULL,
    [Other Provider Identifier State_22] [varchar](50) NULL,
    [Other Provider Identifier Issuer_22] [varchar](50) NULL,
    [Other Provider Identifier_23] [varchar](50) NULL,
    [Other Provider Identifier Type Code_23] [varchar](50) NULL,
    [Other Provider Identifier State_23] [varchar](50) NULL,
    [Other Provider Identifier Issuer_23] [varchar](50) NULL,
    [Other Provider Identifier_24] [varchar](50) NULL,
    [Other Provider Identifier Type Code_24] [varchar](50) NULL,
    [Other Provider Identifier State_24] [varchar](50) NULL,
    [Other Provider Identifier Issuer_24] [varchar](50) NULL,
    [Other Provider Identifier_25] [varchar](50) NULL,
    [Other Provider Identifier Type Code_25] [varchar](50) NULL,
    [Other Provider Identifier State_25] [varchar](50) NULL,
    [Other Provider Identifier Issuer_25] [varchar](50) NULL,
    [Other Provider Identifier_26] [varchar](50) NULL,
    [Other Provider Identifier Type Code_26] [varchar](50) NULL,
    [Other Provider Identifier State_26] [varchar](50) NULL,
    [Other Provider Identifier Issuer_26] [varchar](50) NULL,
    [Other Provider Identifier_27] [varchar](50) NULL,
    [Other Provider Identifier Type Code_27] [varchar](50) NULL,
    [Other Provider Identifier State_27] [varchar](50) NULL,
    [Other Provider Identifier Issuer_27] [varchar](50) NULL,
    [Other Provider Identifier_28] [varchar](50) NULL,
    [Other Provider Identifier Type Code_28] [varchar](50) NULL,
    [Other Provider Identifier State_28] [varchar](50) NULL,
    [Other Provider Identifier Issuer_28] [varchar](50) NULL,
    [Other Provider Identifier_29] [varchar](50) NULL,
    [Other Provider Identifier Type Code_29] [varchar](50) NULL,
    [Other Provider Identifier State_29] [varchar](50) NULL,
    [Other Provider Identifier Issuer_29] [varchar](50) NULL,
    [Other Provider Identifier_30] [varchar](50) NULL,
    [Other Provider Identifier Type Code_30] [varchar](50) NULL,
    [Other Provider Identifier State_30] [varchar](50) NULL,
    [Other Provider Identifier Issuer_30] [varchar](50) NULL,
    [Other Provider Identifier_31] [varchar](50) NULL,
    [Other Provider Identifier Type Code_31] [varchar](50) NULL,
    [Other Provider Identifier State_31] [varchar](50) NULL,
    [Other Provider Identifier Issuer_31] [varchar](50) NULL,
    [Other Provider Identifier_32] [varchar](50) NULL,
    [Other Provider Identifier Type Code_32] [varchar](50) NULL,
    [Other Provider Identifier State_32] [varchar](50) NULL,
    [Other Provider Identifier Issuer_32] [varchar](50) NULL,
    [Other Provider Identifier_33] [varchar](50) NULL,
    [Other Provider Identifier Type Code_33] [varchar](50) NULL,
    [Other Provider Identifier State_33] [varchar](50) NULL,
    [Other Provider Identifier Issuer_33] [varchar](50) NULL,
    [Other Provider Identifier_34] [varchar](50) NULL,
    [Other Provider Identifier Type Code_34] [varchar](50) NULL,
    [Other Provider Identifier State_34] [varchar](50) NULL,
    [Other Provider Identifier Issuer_34] [varchar](50) NULL,
    [Other Provider Identifier_35] [varchar](50) NULL,
    [Other Provider Identifier Type Code_35] [varchar](50) NULL,
    [Other Provider Identifier State_35] [varchar](50) NULL,
    [Other Provider Identifier Issuer_35] [varchar](50) NULL,
    [Other Provider Identifier_36] [varchar](50) NULL,
    [Other Provider Identifier Type Code_36] [varchar](50) NULL,
    [Other Provider Identifier State_36] [varchar](50) NULL,
    [Other Provider Identifier Issuer_36] [varchar](50) NULL,
    [Other Provider Identifier_37] [varchar](50) NULL,
    [Other Provider Identifier Type Code_37] [varchar](50) NULL,
    [Other Provider Identifier State_37] [varchar](50) NULL,
    [Other Provider Identifier Issuer_37] [varchar](50) NULL,
    [Other Provider Identifier_38] [varchar](50) NULL,
    [Other Provider Identifier Type Code_38] [varchar](50) NULL,
    [Other Provider Identifier State_38] [varchar](50) NULL,
    [Other Provider Identifier Issuer_38] [varchar](50) NULL,
    [Other Provider Identifier_39] [varchar](50) NULL,
    [Other Provider Identifier Type Code_39] [varchar](50) NULL,
    [Other Provider Identifier State_39] [varchar](50) NULL,
    [Other Provider Identifier Issuer_39] [varchar](50) NULL,
    [Other Provider Identifier_40] [varchar](50) NULL,
    [Other Provider Identifier Type Code_40] [varchar](50) NULL,
    [Other Provider Identifier State_40] [varchar](50) NULL,
    [Other Provider Identifier Issuer_40] [varchar](50) NULL,
    [Other Provider Identifier_41] [varchar](50) NULL,
    [Other Provider Identifier Type Code_41] [varchar](50) NULL,
    [Other Provider Identifier State_41] [varchar](50) NULL,
    [Other Provider Identifier Issuer_41] [varchar](50) NULL,
    [Other Provider Identifier_42] [varchar](50) NULL,
    [Other Provider Identifier Type Code_42] [varchar](50) NULL,
    [Other Provider Identifier State_42] [varchar](50) NULL,
    [Other Provider Identifier Issuer_42] [varchar](50) NULL,
    [Other Provider Identifier_43] [varchar](50) NULL,
    [Other Provider Identifier Type Code_43] [varchar](50) NULL,
    [Other Provider Identifier State_43] [varchar](50) NULL,
    [Other Provider Identifier Issuer_43] [varchar](50) NULL,
    [Other Provider Identifier_44] [varchar](50) NULL,
    [Other Provider Identifier Type Code_44] [varchar](50) NULL,
    [Other Provider Identifier State_44] [varchar](50) NULL,
    [Other Provider Identifier Issuer_44] [varchar](50) NULL,
    [Other Provider Identifier_45] [varchar](50) NULL,
    [Other Provider Identifier Type Code_45] [varchar](50) NULL,
    [Other Provider Identifier State_45] [varchar](50) NULL,
    [Other Provider Identifier Issuer_45] [varchar](50) NULL,
    [Other Provider Identifier_46] [varchar](50) NULL,
    [Other Provider Identifier Type Code_46] [varchar](50) NULL,
    [Other Provider Identifier State_46] [varchar](50) NULL,
    [Other Provider Identifier Issuer_46] [varchar](50) NULL,
    [Other Provider Identifier_47] [varchar](50) NULL,
    [Other Provider Identifier Type Code_47] [varchar](50) NULL,
    [Other Provider Identifier State_47] [varchar](50) NULL,
    [Other Provider Identifier Issuer_47] [varchar](50) NULL,
    [Other Provider Identifier_48] [varchar](50) NULL,
    [Other Provider Identifier Type Code_48] [varchar](50) NULL,
    [Other Provider Identifier State_48] [varchar](50) NULL,
    [Other Provider Identifier Issuer_48] [varchar](50) NULL,
    [Other Provider Identifier_49] [varchar](50) NULL,
    [Other Provider Identifier Type Code_49] [varchar](50) NULL,
    [Other Provider Identifier State_49] [varchar](50) NULL,
    [Other Provider Identifier Issuer_49] [varchar](50) NULL,
    [Other Provider Identifier_50] [varchar](50) NULL,
    [Other Provider Identifier Type Code_50] [varchar](50) NULL,
    [Other Provider Identifier State_50] [varchar](50) NULL,
    [Other Provider Identifier Issuer_50] [varchar](50) NULL,
    [Is Sole Proprietor] [varchar](50) NULL,
    [Is Organization Subpart] [varchar](50) NULL,
    [Parent Organization LBN] [varchar](50) NULL,
    [Parent Organization TIN] [varchar](50) NULL,
    [Authorized Official Name Prefix Text] [varchar](50) NULL,
    [Authorized Official Name Suffix Text] [varchar](50) NULL,
    [Authorized Official Credential Text] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_1] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_2] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_3] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_4] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_5] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_6] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_7] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_8] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_9] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_10] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_11] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_12] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_13] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_14] [varchar](50) NULL,
    [Healthcare Provider Taxonomy Group_15] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Make this table the output of your dataflow in SSIS.

Good Luck! This should work as I update my own SQL-Server (2008) destination tables based on the import of the NPPES .CSV every month.

回复 原文
一刻暧昧 2024-12-30 16:19:02

您可能已经以不同的方式解决了这个问题，但它对我起作用的方式是：

  1. 创建一个数据流任务
  2. 创建一个平面文件源，并将其指向 CSV 文件。
  3. 关闭DTS包，并在编辑器中打开源文件。它本质上是一个描述包内部工作原理的 XML 文件。
  4. 搜索 DTS:MaximumWidth="50" 并将其替换为 DTS:MaximumWidth="500"。
  5. 保存文件，然后重新打开 DTS 包。双击该任务，在收到有关元数据不一致的一些警告后，您应该没问题了。
  6. 创建 OLE DB 目标，然后将箭头从源拖动到目标。要求它创建一个新的数据库表，其中所有字段均为 varchar(500)。该宽度应该足以将所有字段接收到临时表中。
  7. 运行你的包，看看它是如何工作的。

祝你好运！

You may already have solved this differently, but the way it just worked me was:

  1. Make a dataflow task
  2. Make a flat file source, and point it to the CSV file.
  3. Close the DTS package, and open the source file in the editor. It is essentially an XML file that describes the inner-workings of your package.
  4. Search and replace DTS:MaximumWidth="50" with DTS:MaximumWidth="500".
  5. Save the file, and re-open the DTS package. Double click on the task, and after getting a little warning about metadata inconsistency, you should be fine.
  6. Create an OLE DB destination, and drag an arrow from the source to the destination. Ask it to create a new database table, which will have all the fields as varchar(500). This should be wide enough to receive all your fields into the staging table.
  7. Run your package, and see how it works.

Good luck!

回复 原文
~没有更多了~

关于作者

南…巷孤猫

暂无简介

文章
评论
25 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

kaipeng

文章 0 评论 0

吐个泡泡

文章 0 评论 0

沧桑㈠

文章 0 评论 0

御宅男

文章 0 评论 0

泪眸﹌

文章 0 评论 0

波浪屿的海角声

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文