0

I've been asked to execute/call Stored Procedure from Salesforce.

I'm using SQL Server 2017 Enterprise.

What do I need to execute/call a SQL Server stored procedures from Salesforce?

AjFmO
  • 395
  • 2
  • 4
  • 18
  • 1
    I think the Salesforce hook is the important thing. Absolutely stored procedures are made to be called by outside programs. It sounds like this is a Salesforce api question. – Mike M Jun 15 '19 at 04:07
  • I did an edit to make the question more direct - less "yes/no". Could you specify the versions of SQL Server and of Salesforce? – Mike M Jun 15 '19 at 04:12
  • Unfortunately the edits have added more confusion to an unclear question. Do you want to execute a stored procedure from Salesforce or run a SSIS package? No matter which, a simple search indicates you can't do this [directly](https://salesforce.stackexchange.com/questions/86343/connect-to-external-database-from-salesforce). – SMor Jun 16 '19 at 15:57
  • 1
    @SMor it sounds like OP wants to call a SQL stored proc, from Salesforce, that will execute an SSIS package. – digital.aaron Jun 16 '19 at 19:48
  • 1
    You will need an api to call your sql stored procedure. You can spin one up relatively easy with heroku and using a library to connect to your SQL Server instance. – TemporaryFix Jun 17 '19 at 14:01
  • 1
    Here's a pretty informative post on how to execute SSIS packages from a SQL stored proc: https://www.mssqltips.com/sqlservertip/2992/how-to-execute-an-integration-services-ssis-package-from-a-sql-server-stored-procedure/ – digital.aaron Jun 17 '19 at 16:21
  • @digital.aaron great resource, thanks Aaron – AjFmO Jun 17 '19 at 18:54

0 Answers0