locked
CRM & SSIS RRS feed

  • Question

  • CRM2016

    Our customers send flat files which need to be imported into CRM. Currently I am manually firing the SSIS Package as and when a customer sends a file in. What id like is to be able for my staff to just run a workflow that would fire the SSIS.

    Setting a scheduled task in SQL is not an option as the customers require conformation of file details within minutes.

    Does anyone know of an example workflow that will fire a SSIS, or maybe a ribbon button to fire the SSIS ..


    Dont ask me .. i dont know

    Monday, September 12, 2016 11:30 AM

Answers

  • I dont think it is a good idea to run a workflow to find files from filepath or starting an SSIS package. Rather you could develop a windows service with filewatcher which could trigger when a new file is added to the folder and trigger packages that are configured.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    • Marked as answer by Pete Newman Monday, October 24, 2016 3:36 PM
    Tuesday, September 13, 2016 5:34 AM