activate or execute a ssis package from sharepoint document library

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

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

|||

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

|||

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.

|||

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