Using DTExec on a non SQL Server PC?

  • 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

  • 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

     

  • 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

  • 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

     

  • 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.

  • 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

     

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

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