I need to export the data from a SQL Server table to an iSeries linked server I have already set up (and I know that I can connect to)on that server.
I have done a SELECT INTO but I get an error
"The object name HLDEV.HLDEV.MTRVEND.CARD_MTR' contains more than the maximum number of prefixes. The maximum is 2. (Microsoft SQL Server Native Client 10.0)"
I would appreciate someones assistance in getting me unpickled
asked Aug 13, 2010 at 02:31 PM in Default
SELECT INTO is not supported against linked servers. You'll have to create the tables and populate them with INSERT.
answered Aug 13, 2010 at 03:03 PM