How to Locate the SSIS Installation?

John Saunders

Part of our product will be using several SSIS packages. One of our installers wants to be able to create a .cmd file that will run DTEXEC against one of the packages, with the correct config file specified. It had been assuming that SQL Server was installed in the Program Files special directory, but that's not always the case.

What is the correct way to locate the installation of SSIS In fact:

1. What is the correct way to determine whether SSIS is installed
2. What is the correct way to determine the version and SP that is installed (I want to require SP2)

I had been using the values under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup until I found an SP2 machine with SSIS installed which did not have these keys. Where's the right place to look

Phil Brammer


Well, you can tell if SSIS is installed by looking for the SSIS service in the Admin Control Panel -> Services.

You can launch Visual Studio and then go to help->about to see the SSIS version number.

Or, there's always this:
http://support.microsoft.com/default.aspx scid=kb%3ben-us%3b942177&sd=rss&spid=2855

John Saunders

Thanks for the quick response, Phil.

That article suggests I look in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup. This turns out to be where I used to look!

The odd thing is that I just created and ran a package on a system (a VM) which does not have the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS key at all. In fact, it doesn't have MsDtsServer installed. Yet, I just ran a package on it!

What does this mean The machine in question was upgraded to SP2 from the RTM, but I'm still very confused about the SSIS story on that box.

Phil Brammer

That means that the full SSIS client hasn't been installed. Just the Visual Studio tools.

John Saunders

Thanks. I see I was making a false assumption: I assumed that if you could run a package, that it meant SSIS was installed.