Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Licensing Question


SSIS Licensing Question

Author
Message
rustman
rustman
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2743 Visits: 350
If I am understanding the question right, the bids development environment would be licensed the same way as your server on a client basis. In other words, if you have a Server license and a number of client access licenses, then if you want to use the bids environment on another machine for development then you must have a client access license for it. If you are processor based then you are ok.

Check out the document link from microsoft...it is for sql 2005 as I could not find one for 2008 but it makes sense to me the licensing would be similar and the "shared" tools are basically based on the client model you are following for your server.

http://download.microsoft.com/download/a/6/e/a6ea642a-2dbd-4142-a26d-9c3afe4a2b9e/SQLServer2005StdOEMEULA(English).doc

Oh, and yes I have to agree with Lynn on the development...one of the biggest gains of ssis is the config files which makes remote development and deployment to production a breeze...
Yang-703993
Yang-703993
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 445
You do need license to run SSIS on your local PC. The solution should be purchase a Developer edition of SQL which cause about $100, or if you have MSDN subscription.

have fun!

No Signature
Phil Parkin
Phil Parkin
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10628 Visits: 19857
Note: the post previous to yours is nearly two years old.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
ducon
ducon
SSC-Enthusiastic
SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)

Group: General Forum Members
Points: 179 Visits: 286
You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where you are deploying the package. Works quite easily as simple XML parser capabilities can automate the process.
Phil Parkin
Phil Parkin
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10628 Visits: 19857
ducon (1/13/2014)
You should look into SSIS configuration files. they are simple XML files. This way you can have prod and dev configurations that you substitute based on the environment where you are deploying the package. Works quite easily as simple XML parser capabilities can automate the process.


This has nothing to do with SSIS Licensing.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
ducon
ducon
SSC-Enthusiastic
SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)SSC-Enthusiastic (179 reputation)

Group: General Forum Members
Points: 179 Visits: 286
Your powers of observation are quite strong despite the look of your profile pic Wink.
I was commenting on the old post about the need to troubleshoot and debut packages remotely justifying RDP access which was in this thread.
Phil Parkin
Phil Parkin
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10628 Visits: 19857
ducon (1/13/2014)
Your powers of observation are quite strong despite the look of your profile pic Wink.
I was commenting on the old post about the need to troubleshoot and debut packages remotely justifying RDP access which was in this thread.


You have commented on an off-topic part of a four-year-old thread - without quoting the post you were referencing. Time to stop digging sir :-D


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search