DTS - sql server to AS400

[Boruk]

TRying to pump data from a as400 table into a sql table using DTS. Using Client Access Express ODBC data source. The drop down in the Transform Data Task Properties dialog box shows the tables in the form of "*N"."library name"."table name". If i click on the transformation tab i receive an error ; [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0113 - Name "*N" not allowed.]. If instead of selecting an entire table, i opt to write a sql query for the pump, this works! Client Access is Version 5 Release 1. MDAC for SQL SERVER is 2.7 SP1 on Windows XP professional SP1. Any ideas? Thanks

[K.Forsythe]

DTS - sql server to AS400

The naming convention I would expect to see is LIBRARY.TABLE. Try just removing the leading *N. Good Luck Kevin