Friday, March 9, 2012

msdtssrvr.exe - sql 2005 sp2

Installed sp2 for sql 2005

cannot start msdtssrvr.exe

event viewer returns:

The SQL Server Integration Services service failed to start due to the following error:

The system cannot find the file specified.

I tried to locate the msdtssrvr.exe in C:\Program Files\Microsoft SQL Server\90\DTS\Binn\

I cannot locate the file .

Ron

You need to install SSIS from the installation media. The SSIS service is not installed by default, though I'm surprised you have a service listed for SSIS in the first place.

No comments:

Post a Comment