Post reply

SSIS Deployment - No Integration Services?

  • August 18, 2017 at 2:48 pm

    #332296

    I am doing some development in SSIS after being away from it for a while. I had to setup a quick development database on my own station (SQLEXPRESS / SQL 2016) with Data Tools installed. Loaded the DB, did my work there, made my SSIS package, tested, and it works fine. Now I just want to test out the deployment and running as a SQL job - which requires as a first step to login to Integration Services ... no such luck. I check for the service:

    It's not there. Is this just because I'm in SQLEXPRESS? Is there something new in 2016 I don't know about? I've tried Googling and I've seen things about it being maybe a hidden service ... but that makes no sense. I look for "installing integration service" and all I get is to just install Data Tools ... which I have most certainly created an SSIS package.

    Thanks in advance for you advice!

  • August 18, 2017 at 3:19 pm

    #1955884

    Use developer edition

  • August 18, 2017 at 3:21 pm

    #1955885

    I thought so... but I wanted to check first before I went through the upgrade.

    Thanks!

  • August 18, 2017 at 3:25 pm

    #1955886

    Pretty sure Express doesn't include the advanced things like SSIS.  It should be part of the install (Integration Services).  I actually thought that SQL Server Agent didn't work with express either, but I could be wrong.
    If you don't see SQL Server Integration Services Services in your services list, you didn't install it.

    Looks like Express doesn't support SSIS
    https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server

    I think you will need to install either SQL Standard (non-free) or SQL Developer (which I think is free if I remember right).

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • August 18, 2017 at 3:28 pm

    #1955888

    Just checked. SQL 2016 Developer is FREE. I'm currently backing up my databases as we speak and downloading it.

    https://www.microsoft.com/en-us/sql-server/application-development

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

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