I am running SQL Server 7.0 and currently testing Host Integration Server to copy tables from a database on an AS/400. I have configured the Microsoft OLE DB for DB2 Driver as my Data Source.

I have a few tables on the 400 with # signs in the column name. I get the following error when I try to import SQl Error occured, Please consult the documentation for your specific DB2 version SQLSTATE 42702 SQLCODE:-206.

Any help would be appreciated.