January 2, 2008 at 1:19 pm
Hi All,
I have a package that processes 3 files and loads them into the 400. They are 3 separate processing flows. They all use the same AS400 connection manager which uses the Microsoft OLE DB DB2 driver. I have added a fourth file to be processed and now receive this error when the Data Transform Task tries to load the 400.
[OLE DB Destination [238]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E37 Description: "MYLIBRARY.SYSCOLUMNS is an undefined name. SQLSTATE: 42704, SQLCODE: -204".
Has anyone experienced this error? Why in the world would the OLE DB dest/ AS400 connection start looking for the SYSCOLUMNS table in MYLIBRARY instead of SYSIBM? I can work around it by setting the DEFAULT LIBRARY to SYSIBM in the connection manager and using a SQL Command for the Data Access Mode on the OLE DB Destination, but I shouldn't have too.
Thanks,
Norman
DTS Package Search
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply