Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot find the file MsDtsSrvr.ini.xml Expand / Collapse
Author
Message
Posted Tuesday, September 24, 2013 6:12 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
My SSIS 2008 book says that -

The MSDTSServer100 service is configured through an XML file that is located by default in the following path: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml.

I cannot find this file in the given folder. But, I did find a MsDtsSrvrUtil.dll file which is of no use to me.

The book also says that if you cannot find the path, go to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS\ServiceConfigFile registry key in the Registry. By default, the XML file should look like the following:

< ?xml version=”1.0” encoding=”utf-8” ? >
< DtsServiceConfiguration xmlns:xsd=”http://www.w3.org/2001/XMLSchema”
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” >
< StopExecutingPackagesOnShutdown > true < /StopExecutingPackagesOnShutdown >
< TopLevelFolders >
< Folder xsi:type=”SqlServerFolder” >
< Name > MSDB < /Name >
< ServerName > . < /ServerName >
< /Folder >
< Folder xsi:type=”FileSystemFolder” >
< Name > File System < /Name >
< StorePath > ..\Packages < /StorePath >
< /Folder >
< /TopLevelFolders >
< /DtsServiceConfiguration >

But, I don't see this either inside regedit. All i see is a blank "thing" (photo attached in external link). What is happening and how do I complete these steps ?

[url=http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1ee426a4-8c72-45a0-90f8-d1651b65f65f/cannot-find-the-file-msdtssrvrinixml][/url]
Post #1498092
Posted Wednesday, September 25, 2013 1:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 12,945, Visits: 10,716
Are you sure you have SSIS installed, and if yes, which version?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1498147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse