Error when using openrowset for particular record

[kallem]

Hi,
I am executing following query
[INSERT INTO OPENROWSET('MSDASQL', 'Driver=PostgreSQL Unicode;uid=postgres;Server=localhost;port=5432;da tabase=data;pwd=XXXX',
'SELECT projectCode,projectName,projectDesc,expectedbenifi ts,AttachFileNames,lastupdated,userid
FROM Project WHERE projectCode = ''-1'' ')
SELECT projectCode,projectName,projectDesc,expectedbenifi ts,AttachFileNames,lastupdated,userid from Project where projectCode=1103]

and i am getting following error
Msg 8152, Level 16, State 10
String or binary data would be truncated.

[ck9663]

Just looking at the error message, it means the value you are trying to store is longer than the structure of your table.

Good Luck!!!

~~ CK