MsDtsSrvr.ini.xml file configration

Hi All,

How to configure MsDtsSrvr.ini.xml file in a active\active cluster.

Regards, Balaji Thiruvenkataraju

Add the named instances in, as per your previous post which I answered would make sense. Why, are you having a problem?

MsDtsSrvr.exe memory leak?

In our current environment, we are running about 10,000 packages per day on a given 64 bit SSIS server.

The MSDtsSrvr.exe (SSIS service) process' memory working set size continues to grow until it consumes the memory on the machine.

Some of the packages do use a custom component. Could this be responsible for leaking memory in the MSDtsSrvr.exe process? Has a memory leak been confirmed in this process for the "first-party" components anyway?

More information about the possible memory leak.

The packages are run in in a CLR process with calls Package.Execute(), rather than being executed via dtexec or dtexecui or the designer. The reason for this approach is the ability to write a custom event handler with access to the package pointer, which other log handlers cannot do. The process runs Package.Execute() and exits, so there are 10,000 short-lived processes, each of which call Package.Execute() once.

To be slightly more specific about what the packages are doing, each of the 10,000 packages generally correlates to 1 source file, loading in dummy (aka inferred) dimension records, and then populating a fact table via a surrogate key pipeline.

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.