Invalid string or buffer length

scorpion · Post by **scorpion** » Sat Nov 18, 2006 9:52 am

Hi all,

i am facing an issue when i tried to run the job,it is getting aborting.
the error message i am getting is like,

"Fact_GH_F_XXX..DRS_GH_E_XXX: [Microsoft][ODBC Driver Manager] Invalid string or buffer length"

This fact table design job lookup to some dimension tables,and if lookup matches matched records loads into target fact table and un matched records loads in to error table.

we are using DRS stage and DB is SQLSRVR.

Can any one share idea on this...

Thanx in advance

ray.wurlod · Post by **ray.wurlod** » Sat Nov 18, 2006 10:33 am

Does your table definition (Columns tab) include a VarChar or Char with nothing in the Precision column? There's no such thing as a VarChar(0).