none
activate or execute a ssis package from sharepoint document library

    Question

  • hello all

    i need to execute a ssis(sql 2005 integration service) on a  document document library . can you people help me out how i can do it

    i want to make a work flow which initiate when new document upload in a moss document library and this work flow pass the document to a ssis package and initiate that ssis package

    note: the database and moss servers are on different machine

    please reply ASAP if there any way to do it.

    thnaks

    Monday, March 26, 2007 5:14 PM

Answers

  •  muhammad naeem wrote:

    hello all

    i need to execute a ssis(sql 2005 integration service) on a  document document library . can you people help me out how i can do it

    i want to make a work flow which initiate when new document upload in a moss document library and this work flow pass the document to a ssis package and initiate that ssis package

    note: the database and moss servers are on different machine

    please reply ASAP if there any way to do it.

    thnaks

    Michael Entin has a blog post that will help you here: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

    There are a number of ways of executing SSIS packages, you jest need to see which works best for your scenario.

    -Jamie

     

    Monday, March 26, 2007 10:04 PM

All replies

  •  muhammad naeem wrote:

    hello all

    i need to execute a ssis(sql 2005 integration service) on a  document document library . can you people help me out how i can do it

    i want to make a work flow which initiate when new document upload in a moss document library and this work flow pass the document to a ssis package and initiate that ssis package

    note: the database and moss servers are on different machine

    please reply ASAP if there any way to do it.

    thnaks

    Michael Entin has a blog post that will help you here: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

    There are a number of ways of executing SSIS packages, you jest need to see which works best for your scenario.

    -Jamie

     

    Monday, March 26, 2007 10:04 PM
  • Hi Muhammad,

     

    I have a similar requirement where on document upload in Sharepoint 2003 , I have to execute a SSIS package which will validate and store data in Database. Can you also tell me how you did it and whether it is working.

     

    Regards,

    Swati

    Sunday, April 29, 2007 7:16 AM
  •  

    Hi swati

     

    ya i can give you a idea that how am i done it 

     

    my issue is related with MOSS 2007 not on 2003.i start my work on SharePoint after the 2007 release so don’t know about that how can you do it on 2003 but here is the procedure which i use in moss 2007 

     

    I first create a work flow which have InfoPath form for configuration. in  which i take the sp name the take two parameters one the url of the uploaded document and the other is the SSIS package name.

    In this work flow I execute that sp by giving the ssis pacage name and the current document. In that sp a execute the dtsexe.exe(detail in linked below) to activate ssis package.

     

    Then I attach this work flow with document library.

     

    I got help from these two posts. You can too find more detail from them.

     

    Michael Entin blog post 

     http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx

     and  Jeff Modzel belogs

    http://www.codeproject.com/useritems/CallSSISFromCSharp.asp 

     

    if you need then I can give you code too.

     

    Monday, April 30, 2007 9:57 AM
  • Hi Muhammad,

     

    Thanks for your quick response. What is sp, if it is stored procedure, then how to take stored proc name in Infopath forms. Can you please send me the code, including the infopath form at pashmina_15@yahoo.com

     

    I need to learn how to create workflow and how to attach workflow with document library.

     

    Also does this solution helps to solve the purpose, i.e. Whenever a new document is uploaded / updated to document library it will trigger SSIS package?

     

    Thanks once again for your quick help.

     

    Regards,

    Swati

    Thursday, May 03, 2007 12:33 AM
  • Hi guys,

     

    I am also trying to do what Swati was attempting to do here.  Please could anyone share the outcome of how to call an SSIS package from a SharePoint or Windows Workflow Foundation workflow when a document is loaded to a Doc Library.  I'd also be really interested to learn how it might be possible to monitor the progress of the package and report errors or validation failures.

     

    Many thanks

     

    Simon.

     

    Monday, December 10, 2007 4:12 PM
  • Is this discussion still active, if so could please respond to the above two posts, as i am looking for the same solution.

     

    thank you,

     

    Achyuth.

    Monday, August 15, 2011 11:15 PM