I have an 2008 R2 package that has seven data flow tasks going from SQL Server 2008 to the same DB2 table. Six of the seven flows work great, but one (2nd in the chain) returns an error message:
[OLE DB Destination ] 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: "DTA.SYSCOLUMNS is an undefined name. SQLSTATE: 42704, SQLCODE: -204".
Question: What's the 'SYSCOLUMNS is an undefined name' ?
I dropped and re-created the DB2 destination, remapped, same errmsg.
Thanks in advance.
( SSIS and SQL expert, DB2 N00b )