I cannot import SSIS package into MSDB folder.

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

  • How are you deploying the package?

  • Using SSMS intergration service. I could login into the server using administrator access

  • Have you tried deploying the package from BIDS using the deployment tool?

  • No, I only two ways to deploy SSIS.

    One is on BIDS Click File->save copy as-> and then select the package store and file. -- this is not working for me.

    Another is using SSMS integration services. -- Not working.

    I can learn about this deployment tool too.. Is this any kind of software tool?

  • It is a part of BIDS. I haven't worked with SSIS for a while so you should do some research in BOL (Books Online).

  • Hi,

    Another way of deploy that package is right click the project name in the solution explorer . one pop menu will appear. choose deploy it launches the screen . Here you have to give the deployment path . If u need deployment manifest file choose that option also. It will create one file which is located in where your package available.

    In that folder click that newly created manifest file It will ask details about that package..then proceed with based on the dialogue box questions..

  • srilu_bannu (3/27/2013)


    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:

    ...

    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?

    Under which name is the SQL Server database engine installed? Under the default instance or under nyab?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Did you say you ARE or ARE NOT able to open the server in SSMS and import the package that way?

    Steps would be: Open SSMS, connect to Integration Services with the server name, the folders listed should be Running Packages and Stored Packages. MSDB is usually listed underneath Stored Packages.

    Can you do that kind of deployment?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Koen, I have Database engine installed on default instance which is on nycab server.

    Brandie, I couldn't import the package after i go to SSMS, choose SSIS service and under MSDB folder i right clicked to import package and when i select the file and click ok i get the error i mentioned.

  • srilu_bannu (3/29/2013)


    Koen, I have Database engine installed on default instance which is on nycab server.

    Brandie, I couldn't import the package after i go to SSMS, choose SSIS service and under MSDB folder i right clicked to import package and when i select the file and click ok i get the error i mentioned.

    Is the SSIS service installed on another machine?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • No, it is not installed on other machine.

    Actually, i installed SSIS on nyabc server last week. I have added SSIS feature and restarted the server. When i tried to open SSMS to deploy the package i got the error and i searched Google and changed msdtdsrvr.ini file like below.

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

  • If you install SSIS on the same machine as the database engine where the MSDB database resides, you normally don't need to edit the configuration file.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Are you sure your account has the correct ssisadmin permissions on msdb on that server?

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply