Solved

ssis-licensing

Posted on 2014-04-11
3
238 Views
Last Modified: 2016-02-10
if we want only ssis and not sql instance on a box, how does licensing work for that?

is there seperate licensing (standard, enterprise etc ) for ssis?
0
Comment
Question by:25112
  • 2
3 Comments
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
>if we want only ssis and not sql instance on a box
I've run into this a couple of times, and installing SSIS (or dtexec.exe) on a box separate from a full SQL Server or BIDS is not possible.

The last time, we had to Remote Desktop into a box that did have SQL Server installed, copy the .dtsx project file there, create a .bat file to run it, and go into Windows Task Scheduler to schedule a task to run the .bat.

Good luck.
Jim
0
 
LVL 5

Author Comment

by:25112
Comment Utility
so you are suggesting that SSIS needs same licensing as a license for SQL Server instance (if SSIS is the only 'sql' install on the server from the SQL DVD)?

So you could/would classify SSIS standard vs SSIS Enterprise and so forth.
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
Comment Utility
Yes.  There is no such animal as an SSIS license.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package). The latter is certainly a headache for developers, particularly for me. We had to ma…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now