UPDATE...FROM syntax

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

UPDATE...FROM syntax

Postby sray » Wed Feb 29, 2012 11:42 am

Is it possible to do the following type of query with PGNP?

Code: Select all
UPDATE [SERVER].[DB].[SCHEMA].[TABLE] SET
   field1 = 'Some Value',
   field2 = 'Another Value',
   field3 = source.value
FROM
   [SQL SERVER TABLE] AS source
WHERE
   key_field = source.key_field


In testing it works as long as [SQL SERVER TABLE] only contains 1 row. Any more rows and I get the following error:

Cannot get the data of the row from the OLE DB provider "PGNP" for linked server "bbi".


I would use an UPDATE OPENQUERY however I need to set values based on a local SQL Server table. I would rather not have to create a temporary destination table, insert the rows there and then do an update query via OPENQUERY or EXEC if possible.

Thanks for any input,

Seoras.
sray
 
Posts: 5
Joined: Tue Feb 28, 2012 10:59 am

Re: UPDATE...FROM syntax

Postby Moderator » Mon Mar 05, 2012 11:08 pm

This is a defect. We are working on a fix, and will let you know when fix is ready.
User avatar
Moderator
Site Admin
 
Posts: 293
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: Majestic-12 [Bot] and 2 guests

cron