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 import package into MSDB. Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 10:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:07 PM
Points: 154, Visits: 681
Hi all,
I am working on SSIS and created integrated services project and saved them under a new folder.
I want to deploy them under msdb folder and schedule the package but, i am getting this error:

The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information see the topic "Configuring the Integration Services" in Books online....

I have searched google and changed the msdtdsrvr.ini under C:\Program Files\Microsoft SQL Server\110\DTS\Binn..

FROM:

<?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>


TO:

<?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>nyabc</ServerName> ----This is changed
</Folder>
- <Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>


I couldn't give the instance name because our SQL Server is installed on default instance mssqlserver so i gave only server name nyabc.

No matter how i change the part <ServerName>nyabc</ServerName> i was unable to load the package into msdb folder. It is giving the same error even after restarting ssis service.

Can anyone please tell me what is the wrong i am doing here? How should i import packages to msdb folder and schedule them?



Post #1435599
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse