Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SQL Trigger to Insert into Salesforce

Hi,
I can insert into SALESFORCE...Account by running query manually and the trigger is doing the same but it doesn't work. Please Help.

My Trigger:

IF OBJECT_ID('dbo.insLocal_Account') IS NOT NULL
DROP TRIGGER dbo.insLocal_Account
GO

CREATE TRIGGER dbo.insLocal_Account
ON dbo.Local_Account
AFTER INSERT AS
BEGIN
INSERT INTO SALESFORCE...Account
( NAME
)
SELECT NAME
FROM inserted;
END;
GO

My TEST Insert:
USE salesforce_backups;
INSERT INTO Local_Account (Name) VALUES ('Account #1');

Here's the error messages:
Msg 8501, Level 16, State 3, Procedure insLocal_Account, Line 6
MSDTC on server 'GVH-OLD-1\LOCALDB#68576B90' is unavailable.

Thank you.

Sonny Huynh
1 person has
this question
+1
Reply