locked
Call SSIS package from syncronous plug-in RRS feed

  • Question

  • Hi,

    Is it advisable to call SSIS package from syncronous plugin (by considering performance and fail-over mechanism)?

    Thanks!


    Vinayak Chavan

    Friday, June 28, 2013 9:39 AM

Answers

  • For performance reasons, I would not advise this. SSIS packages are compiled on demand, and this would cause an excessive processing overhead in terms of response time to the client. If the plugin is asynchronous, then the response time is not a problem, though you will still need to consider the overall processing load

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by VinayakChavan Tuesday, July 2, 2013 6:59 AM
    Friday, June 28, 2013 12:33 PM
    Moderator

All replies

  • For performance reasons, I would not advise this. SSIS packages are compiled on demand, and this would cause an excessive processing overhead in terms of response time to the client. If the plugin is asynchronous, then the response time is not a problem, though you will still need to consider the overall processing load

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by VinayakChavan Tuesday, July 2, 2013 6:59 AM
    Friday, June 28, 2013 12:33 PM
    Moderator
  • Thanks for your valuable input!

    Vinayak Chavan

    Tuesday, July 2, 2013 6:59 AM