SQL Server text file import error: The number of input columns cannot be zero

Question

I am having a problem with the SQL Server Import Wizard. I am importing a text file without headers into an existing table (via append rows to the destination table). On the text file, some of the columns at the end are NULL. (Their corresponding columns in the table are nullable.) On the Column Mappings step, the columns that are NULL do not appear in the mappings. When the validations step occurs in the import, it throws the following error:

Error 0xc020201b: Data Flow Task 3: The number of input columns for Destination 13 - some_table.Inputs[Destination Input] cannot be zero. (SQL Server Import and Export Wizard)

Is this occurring because I haven't specified the mapping for the columns that are NULL? If so, how do I specify them in the mapping? I don't see a way to add columns other than the ones that the Wizard detects in the file.

is it a delimited text file? I guess i don't undestand this text file. let me know if its correct what i'm saying: In the first row of the textfile you have all the columns that exists in the destination table but the are some rows that have just a few columns? — FpontoDesenv
– FpontoDesenv, Commented Nov 20, 2014 at 1:41
Yes, it's a delimited text file. However, the first row does not contain the column headers. The first row contains data. — skyline01
– skyline01, Commented Nov 20, 2014 at 14:32
I figured out my problem. My source file didn't have delimiters between the columns at the end that are NULL. So, it didn't even see them as columns. — skyline01
– skyline01, Commented Nov 20, 2014 at 17:58

Ed_ · Accepted Answer · 2015-07-14 19:50:24Z

1

Someone can also get this message If you happen to not choose a specific destination column

answered Jul 14, 2015 at 19:50

Ed_

1,13713 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

skyline01 · Accepted Answer · 2014-11-20 17:59:41Z

0

I figured out my problem. My source file didn't have delimiters between the columns at the end (the right) that are NULL. So, it didn't even see them as columns.

answered Nov 20, 2014 at 17:59

skyline01

2,17310 gold badges40 silver badges68 bronze badges

Collectives™ on Stack Overflow

SQL Server text file import error: The number of input columns cannot be zero

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related