Uwaga
Dostęp do tej strony wymaga autoryzacji. Może spróbować zalogować się lub zmienić katalogi.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
Have you find this error while trying to navigate your packages? Today, testing for the first time a SQL Server installation with some SSIS packages, the system gave me this message.
You may find some answers related to this message as https://sqljunkies.com/WebLog/ashvinis/archive/2005/03/29/9831.aspx
But after checking that I realized it was not the real problem, so I started to think in my scenario:
- Named Instance SQL Server 2005 installation Side by Side with a SQL Server 2000 installation
So we should take a closer look at the SSIS configuration...Configuring the Integration Services Service
"By default, the file is located in the folder, Program Files\Microsoft SQL Server\90\DTS\Binn, and the file name is MsDtsSrvr.ini.xml"
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="https://www.w3.org/2001/XMLSchema" xmlns:xsi="https://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>
Hey, ServerName it is not pointing to the named Instance!!
So after changing it to a ServerName\InstanceName everything worked as expected.