Five Stars

The identifier that starts with ... is too long. Maximum length is 128

I have multiple "Excel to Database" job, but the last one i did gives me the error :

 

The identifier that starts with '[...]' is too long. Maximum length is 128. 

 

Compare to the other jobs, this one has over 300k row to insert, where the other only have around 10k. I've tried reducing the number of row to test, but it still happens. It also has less column than the one with 10k rows, so i'm really lost here on why this happen.

3 REPLIES
Four Stars

Re: The identifier that starts with ... is too long. Maximum length is 128

Do you have in the header one of the column name with more than 128 characters ?

Five Stars

Re: The identifier that starts with ... is too long. Maximum length is 128

No, longuest one is 20.

Five Stars

Re: The identifier that starts with ... is too long. Maximum length is 128

 

The part i cut of ( [...] ) is actually this:

 

[Payment Condition],[[Handling unit]) VALUES ( @P0 , @P1 , @P2 , @P3 , @P4 , @P5 , @P6 , @P7 , @P8 , @P9 , @P10 , @P11 , @P12 , 

 

It counts 128 character.I have 30 columns in totals and like i said, i've had other job doing the same as this and it didn't brought up this error.