Cannot import package into MSDB.

• srilu_bannu

  Hall of Fame

  Points: 3100

  More actions

  March 26, 2013 at 10:15 am

  #275675

  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?