We are trying to access some AS400/DB2 tables using Link-Server o
SQL-Server 2003. The actual query is part of a DTS package. For accessin
the tables 'DB2OLEDB' driver is used, this driver is available as part o
the Host Integration Server - 2000.

Following are the versions of all the drivers etc

SQLServer - 2003, SP
HIS (Host Integration Server) - 2000, SP

The query returns the following error sometimes
OnError(DTSStep_DTSExecuteSQLTask_1, -2147217900, Microsoft OLE D
Provider for SQL Server, OLE DB provider 'DB2OLEDB' returned a
unexpected data length for the fixed-length column '[DB2OLEDB].V7PATC'
The expected data length is 1, while the returned data length is 0.,
0

According to Microsoft KB Article - 277871
(http://support.microsoft.com/default...;EN-US;277871), the issu
has been resolved as part of SNA Server 4.0, SP4.

But the problem persist with HIS-2000 SP1.

We would appreciate a resolution of the above issue from your side

Thank
HP