Hello,

Thanks for the reply. This is the error I get once I execute the script in powershell:

Get-ChildItem : Cannot find path 'C:\Users\System.Data.DataRow' because it does not exist.

At C:\Users\Get-Permissions.ps1:18 char:28

+...

Hi,

So you cannot INSERT into a different table to the target?

EDIT: Does anyone know why this code still is not working?

There is no actuall error on the code...

.

Hello,

OK I have added the schema in bold still no luck. This is just making all my code error. when before it was just the last update statement.

MERGE tblInstances...

Hello,

My schema is .dbo. Your solution below did not work. Any other suggestions?

MERGE tblInstances AS TARGET

USING tblInstanceImport AS Source

ON (Target.InstanceName= Source.InstanceName)

WHEN MATCHED THEN

UPDATE

SET tblInstances.dbo.[Home] = Source.dbo.[Home]

,tblInstances.dbo.[Version] = Source.dbo.[Version]

,tblInstances.dbo.[DateCollected] =...

Hello,

This failed to work. Any other suggestions?

MERGE tblInstances AS TARGET

USING tblInstanceImport AS Source

ON (Target.InstanceName= Source.InstanceName)

WHEN MATCHED THEN

UPDATE

SET [Home] = Source.[Home]

,[Version] = Source.[Version]

,[DateCollected] = GetDate()

WHEN NOT MATCHED BY TARGET THEN

UPDATE

SET...

Hello,

Thank you for your quick response but unfortunately this has not worked, I am still getting the same error 'The multi-part identifier could not be bound'.

MERGE tblInstances AS TARGET

USING...