SQL2005开发版SSIS正常连接需要修改的地方
很久没有使用SSIS了,最近重新安装了系统,偶尔使用一下,发现要正常使用,还是需要做下面一个修改步骤的:
文件名:
MsDtsSrvr.ini.xml
(缺省目录:C:\Program Files\Microsoft SQL Server\90\DTS\Binn\)
修改:红色字体的地方,缺省情况下是一个“.”,应改为目前的内容。
<?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>DBSERVER\InstanceName</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
文件名:
MsDtsSrvr.ini.xml
(缺省目录:C:\Program Files\Microsoft SQL Server\90\DTS\Binn\)
修改:红色字体的地方,缺省情况下是一个“.”,应改为目前的内容。
<?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>DBSERVER\InstanceName</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>