these issues are notoriously hard to dig for...there's a connect item out there stating why not add the column name of the violating size issue to the error message.
because this is a parameterized query, what you need is right there in front of you...you just have to become familiar with parsing it out:
this part:
@P1 varchar(8),@P2 bigint,@P3 varchar(1),@P4 varchar(1),@P5 varchar(1),@P6 bigint,@P7 bigint,@P8 bigint,@P9 varchar(8),@P10 varchar(6),@P11 varchar(1),@P12 varchar(1),@P13 float,@P14 float,@P15 float,@P16 float,@P17 float,@P18 varchar(9),@P19 varchar(8),@P20 varchar(1),@P21 varchar(1),@P22 varchar(7),@P23 varchar(1),@P24 varchar(1),@P25 varchar(1),@P26 varchar(1),@P27 varchar(1),@P28 varchar(1),@P29 varchar(1),@P30 varchar(1),@P31 varchar(1),@P32 varchar(1),@P33 varchar(1),@P34 float,@P35 float,@P36 float,@P37 float,@P38 varchar(1),@P39 varchar(1),@P40 varchar(1),@P41 varchar(1),@P42 varchar(1),@P43 varchar(1),@P44 bigint,@P45 bigint','07030492',2,'','A','',0,12621600,10516320,'30/12/07','111111','','',112000,0,0,0,0,'189604.21','49158.47','','','UNKNOWN','','','','','','','','','','','',0,0,0,0,'','','','','','',0,1
has both the parameters, the param sizes,and the values. and the insert statement has the column names...a little copy/paste and formatting lets you look at it like what I've pasted below.
what you need to do is compare it to the column definitions...and it should be easy, you KNOW it's a text column of some type, there's only 6 varchars that are not varchar(1) being passeds, so compare the parameters to table definition, and you should be able to visually find the column quickly..
according to my copy/pastes, there should be 45 values, 45 parameters, but i only saw 42 columns in what you pasted.
'07030492', clasik.dbo.LOADFNC.FNCNUM , @P1 varchar(8),
2, clasik.dbo.LOADFNC.LINE , @P2 bigint,
'', clasik.dbo.LOADFNC.FNCPATNAME , @P3 varchar(1),
'A', clasik.dbo.LOADFNC.IVNUM , @P4 varchar(1),
'', clasik.dbo.LOADFNC.FNCREF2 , @P5 varchar(1),
0, clasik.dbo.LOADFNC.BALDATE , @P6 bigint,
12621600, clasik.dbo.LOADFNC.CURDATE , @P7 bigint,
10516320, clasik.dbo.LOADFNC.FNCDATE , @P8 bigint,
'30/12/07', clasik.dbo.LOADFNC.ACCNAME , @P9 varchar(8),
'111111', clasik.dbo.LOADFNC.IACCNAME , @P10 varchar(6),
'', clasik.dbo.LOADFNC.BUDCODE , @P11 varchar(1),
'', clasik.dbo.LOADFNC.COSTCNAME , @P12 varchar(1),
112000, clasik.dbo.LOADFNC.SUM1 , @P13 float,
0, clasik.dbo.LOADFNC.SUM2 , @P14 float,
0, clasik.dbo.LOADFNC.EXCHANGE2 , @P15 float,
0, clasik.dbo.LOADFNC.SUM3 , @P16 float,
0, clasik.dbo.LOADFNC.EXCHANGE3 , @P17 float,
'189604.21', clasik.dbo.LOADFNC.CODE3 , @P18 varchar(9),
'49158.47', clasik.dbo.LOADFNC.DEBIT , @P19 varchar(8),
'', clasik.dbo.LOADFNC.DNAME , @P20 varchar(1),
'', clasik.dbo.LOADFNC.TEXT , @P21 varchar(1),
'UNKNOWN', clasik.dbo.LOADFNC.CASHFLOWCODE , @P22 varchar(7),
'', clasik.dbo.LOADFNC.FNCICODE , @P23 varchar(1),
'', clasik.dbo.LOADFNC.FNCIREF1 , @P24 varchar(1),
'', clasik.dbo.LOADFNC.FNCIREF2 , @P25 varchar(1),
'', clasik.dbo.LOADFNC.DETAILS , @P26 varchar(1),
'', clasik.dbo.LOADFNC.COSTCNAME2 , @P27 varchar(1),
'', clasik.dbo.LOADFNC.COSTCNAME3 , @P28 varchar(1),
'', clasik.dbo.LOADFNC.COSTCNAME4 , @P29 varchar(1),
'', clasik.dbo.LOADFNC.COSTCNAME5 , @P30 varchar(1),
'', clasik.dbo.LOADFNC.QUANT1 , @P31 varchar(1),
'', clasik.dbo.LOADFNC.SUM4 , @P32 varchar(1),
'', clasik.dbo.LOADFNC.SUM5 , @P33 varchar(1),
0, clasik.dbo.LOADFNC.EXCHANGE5 , @P34 float,
0, clasik.dbo.LOADFNC.CODE5 , @P35 float,
0, clasik.dbo.LOADFNC.DOCNO , @P36 float,
0, clasik.dbo.LOADFNC.WBS , @P37 float,
'', clasik.dbo.LOADFNC.CUSTNAME , @P38 varchar(1),
'', clasik.dbo.LOADFNC.BRANCHNAME , @P39 varchar(1),
'', clasik.dbo.LOADFNC.VATTYPE , @P40 varchar(1),
'', clasik.dbo.LOADFNC.IVCOUNT , @P41 varchar(1),
'', clasik.dbo.LOADFNC.T$USER @P42 varchar(1),
'', @P43 varchar(1),
0, @P44 bigint,
1 @P45 bigint
Lowell