SQL Server Licensing for DTS

I'd like to distribute some Data Transformation Services (DTS) packages that I've developed for customer use. What kind of SQL Server license do my customers need if their users run DTS packages but don't need access to SQL Server tools?

Technically, you don't need a SQL Server license to run a DTS package. You can legally redistribute the core DTS files that Figure 1 lists.

You can also distribute DTS packages as .dts files. Users can then run a package by using the dts-run.exe command-line tool, or you can write custom programs to call the DTS COM objects directly.

Users do need a valid SQL Server license if they're going to use the DTS Designer to open or edit a package. In addition, users need a SQL Server license if the DTS package connects to SQL Server for any reason.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.