SSIS and SQL Express

• Kurt Marr

  SSC Veteran

  Points: 255

  More actions

  September 21, 2006 at 1:39 am

  #169818

  I am trying to prove is whether an integration service package can be executed against a SQL Express 2005 database.

   

  We have 80 clients that we are planning to roll out SQL Express to as the db and I would like to know if I develop the SSIS package using my local full blown version of SQL Server 2005 can I then package it up and send it out along with the application (C# Winforms, clickOnce deployment)  and the package be executed on the client machine that will only have SQL Express installed?

    

  I can't tell if the documentation refers to the ability to create SSIS packages is not in SQL Express Management Studio or whether it can not be run against it?

   

  thanks

  Kurt

• September 25, 2006 at 8:00 am

  This was removed by the editor as SPAM

• debrucer1

  SSCertifiable

  Points: 5366

  More actions

  September 28, 2006 at 10:49 am

  #663083

  It cannot be created in Express.  I can run against the Express instance.

  Thank-you,
  David Russell
  Any Cloud, Any Database, Oracle since 1982