Executing SSIS package from .Net without having Business Intelligence Installed

• rajeshvaswani1977

  SSC-Addicted

  Points: 482

  More actions

  July 30, 2009 at 2:01 am

  #212753

  Hi All,

  I am looking at developing a Migration ASP.NET application that will accept Database Cardentials for source and destination. Later Runs through some UI so that the user can make changes as to whats needed from the source and whats not, this i log in to tables I call as my custom config tables. I look at the custom config tables and generate an SSIS package dynamically. My question is when i want to execute this SSIS package from .Net code(say a C# component). Do i need Business Intelligence to be installed? Ideally i want to do execution where there is no requirement that BI has to be installed. Is this possible?

  Thanks in Advance

  Rajesh Vaswani

• denglishbi

  SSCrazy Eights

  Points: 8831

  More actions

  July 31, 2009 at 9:10 pm

  #1033260

  Take a look at these postings:

  Loading and Running a Local Package Programmatically

  http://msdn.microsoft.com/en-us/library/ms136090.aspx

  Running SSIS package programmatically

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

  ----------------------------------------------------------------------------------------
  Dan English - http://denglishbi.wordpress.com