September 24, 2013 at 6:12 pm
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 ?
September 25, 2013 at 1:08 am
Are you sure you have SSIS installed, and if yes, which version?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply