February 27, 2006 at 9:24 pm
There was an option with SQL 2000 DTSRun to install and register about 6 files on a non SQL Server machine so that DTS Packages could be run. Does this option exist for SQL 2005 SSIS?
Thanks,
Dick Campbell
March 1, 2006 at 2:37 am
The only pre-requisite to run packages via DTExec (i.e. the replacement for DTSRun) is to install Integration Services, you don't need to install workstation components.
I think this is analogous to installing only the DTS Runtime as opposed to Enterprise Manager as well which is what you are describing here.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
March 1, 2006 at 3:31 am
Thanks Jamie,
With DTS we were given a list of files and told which ones to register(in Redist.txt) . It sounds like this has been tidied up a lot. Are there any licensing restrictions that you know of when it comes to installing SSIS on multiple non SQL Server PCs?
Dick campbell
March 1, 2006 at 3:42 am
I am no licensing expert so I can only tell you what we are currently doing. The client I am working for has an MSDN subscription which (I think) means you can install Developer Edition on workstations. You will of course need a seperate license for all servers in your live environment.
I would ask someone who knows more about licensing than I do tho!
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
March 1, 2006 at 12:29 pm
Thanks,
The afore-mentioned redist.txt basically stated that the DTS files could be freely distibuted (I think in association with an original SQL Server License). I am yet to find smilar information for SQL 2005.
March 1, 2006 at 1:33 pm
Oh right. Well I do know the answer to this one.
You need a license for every machine on which you install a component of SQL Server. So you won't be able to get it for free.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply