SSIS and SQL Express

  • Kurt Marr

    SSC Veteran

    Points: 255

    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

  • Rick Heiges

    SSChasing Mays

    Points: 660

    SSIS is not part of SQL Server Express.  There is no "run time" version of SSIS like there was for DTS.  If I remember correctly from a white paper on the MSFT site concerning upgrading from MSDE to Express, you can still download/run the DTS run-time environment against an Express DB. 

    Hope this helps!

  • Kurt Marr

    SSC Veteran

    Points: 255

    thanks Rick...

    that is a shame...there is no way that our clients (universities, colleges, etc) are going to buy another version simply to allow us to develop a solution for them.

     

     

  • Gift Peddie

    SSC Guru

    Points: 73570

    I have good news if you download the Adanced you will get Management Studio and service pack one comes with DTS it is not integrated services but it can help you move you databases.   And you need to over ride the default in the service pack.  If ou don't see it in SQL Server folder after applying the service pack run it again.  Hope this helps.

    http://www.microsoft.com/downloads/details.aspx?familyid=11350B1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en

    http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en

    Kind regards,
    Gift Peddie

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply