by Odd, I've never seen this one. It looks like it is picking up the default
OGPL library OK, but using*N as some form of database name.
I would guess that the OBDC driver is not correctly configured. I generally
create one ODBC link for each AS400 library (on each machine) I want to pick
up data from, and set the default library for the link to that library
rather than OGPL. When I view the list of tables, I don't get the machine
name in front.
Try using the package designer rather than the wizard, I don't know what the
wizard picks up, as I've never used it.
Hope this helps at least a bit,
Richard
Everytime I bring up my list of files from my AS/400 data source a "N" is
placed in front of each available table. When I try to preview a transfer
selection I get the following error
SQL0113 "N" is not a valid name. It should be placing the name of my AS/400
in the box, but it appears that this N is replacing the name of the server.
I have attached two print screens of the error for review.