locked
Execute Stored Procedure RRS feed

  • Question

  • Hi guys,

    What is the best practice to execute a stored procedure?

    By the way the stored procedure below is executing a SSIS package. 

    Any step by step instructions would be great. Unfortunately my last project I worked on Lightswitch was 5 years ago used VS 2010

    I'm currently using VS2013 for this project, I'm still trying to wrap my head around it :-) 

    declare @output_execution_id bigint
    exec [dbo].[ExecuteMoveDataToLegacy] @output_execution_id output

    Thank you 


    Codernater

    Tuesday, July 28, 2015 9:50 PM

Answers

  • This looks like a fairly complete description of how to do it.

    • Proposed as answer by Xpert360 Wednesday, July 29, 2015 11:38 AM
    • Unproposed as answer by Codernater Wednesday, July 29, 2015 3:03 PM
    • Marked as answer by Codernater Thursday, July 30, 2015 1:45 PM
    Wednesday, July 29, 2015 4:18 AM

All replies

  • This looks like a fairly complete description of how to do it.

    • Proposed as answer by Xpert360 Wednesday, July 29, 2015 11:38 AM
    • Unproposed as answer by Codernater Wednesday, July 29, 2015 3:03 PM
    • Marked as answer by Codernater Thursday, July 30, 2015 1:45 PM
    Wednesday, July 29, 2015 4:18 AM
  • Initially I stumbled into this link. However, this doesn't support my purpose. It supports the CRUD model.

    I'm trying to execute SSIS package using stored procedure. 

    Thanks

     

    Codernater

    Wednesday, July 29, 2015 3:06 PM
  • This gets you from LS to the SP.  Are you saying you need help with getting the SP to do SSIS?  I don't know the answer to that one but there might be other forums that are better for the SP side of the question if the LS portion is sufficiently resolved.
    Wednesday, July 29, 2015 8:07 PM