DTEXEC (SSIS) - minimum install & license cost - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

eek replied

19 August 2016, 11:19
You will need a full licence for SSIS (it doesn't come in SQL Express and you can't use a Developer licence for Production work).

The other question would be could you use a hosted sql server virtual machine either in Azure or AWS which would be billed just for the hours its switched on...
Leave a comment:
DimPrawn replied

19 August 2016, 10:13
I didn't think Sql Server Express could run an SSIS package? I'm sure you can create SSIS packages with BIDS, but you can't run them using SS Express?
Leave a comment:
jaffab replied

19 August 2016, 09:47
How big is your database going to be? What version of SQL Server do you need as a minimum? How long will the database be up/used for?
If its small (<= 15gb), you dont need SQL server 2014/2016 or it wont be up for too long, you could get away with an installation of SQL Server express (free) which comes with BIDS therefore provides all you need.
Leave a comment:
DimPrawn replied

19 August 2016, 09:39
It would be nice if SSIS could be run in Azure wouldn't it?

https://feedback.azure.com/forums/21...s-in-sql-azure
Leave a comment:
Intel replied

19 August 2016, 06:50
Yep, it's a full SQL Server license. Your best bet in that scenario is a server plus cal model. Core licensing would be crazy. You may be able to get away with standard edition if you don't use any enterprise components in your ssis package.
Leave a comment:
Einstein Jnr replied

18 August 2016, 19:44
I remember having a similar discussion years back about SSRS and the conclusion was they are features or components of SQL so you need a full SQL license on every server you put it on. I assume that would the case for SSIS, but then again MS licensing changes by the hour.
Leave a comment:
zazou started a topic DTEXEC (SSIS) - minimum install & license cost

18 August 2016, 11:36
DTEXEC (SSIS) - minimum install & license cost

If I wanted to run an SSIS package on a Windows Server 2012, what's the minimum install I can get away with and what are the cost implications?

It's a bare bones production server, no SQL Server installation present. The SSIS package will communicate with SQL Azure.

Has anyone here been faced with a similar situation?
Tags: None