Deploy and Execute SSIS package on non-MSSQL machine

• tpitts

  Newbie

  Points: 1

  More actions

  June 25, 2007 at 6:11 am

  #177202

  I have developed an SSIS package and need to deploy/execute it on a machine that does not have MSSQL Server installed. Can I install only the SSIS components on a machine or does it come bundled with MSSQL?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 25, 2007 at 7:12 am

  #714910

  You can install client components and use them to deploy or execute the SSIS package.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Ram-425798

  Right there with Babe

  Points: 748

  More actions

  June 29, 2007 at 12:27 pm

  #716278

  Hi Sugesh,

  How do I make a dll of SSIS package ? Is installing different than deploying? I am confused here. Can you please guide? Which one is better?

  thx,

  Ram

• Carla Hepker

  Ten Centuries

  Points: 1235

  More actions

  July 10, 2007 at 11:34 am

  #718364

  Sugesh,

  I understood that executing an SSIS package is not part of the client component in SQL 2005.

  I have installed the client on a machine, but it is not possible to execute an SSIS dtsx on that machine.

  Carla

  ---

  Regards,

  Carla Hepker
  Documentation: A Shaft of light into a coded world.