March 27, 2013 at 9:34 am
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?
March 27, 2013 at 11:01 am
How are you deploying the package?
March 27, 2013 at 11:13 am
Using SSMS intergration service. I could login into the server using administrator access
March 27, 2013 at 11:18 am
Have you tried deploying the package from BIDS using the deployment tool?
March 27, 2013 at 11:26 am
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?
March 27, 2013 at 11:31 am
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).
March 28, 2013 at 12:42 am
You can get more information on deployment of SSIS packages in the msdn site.....
http://msdn.microsoft.com/en-us/library/ms137592.aspx
http://msdn.microsoft.com/en-us/library/ms162820%28v=sql.105%29.aspx
March 28, 2013 at 1:09 am
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..
March 28, 2013 at 3:56 am
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
March 28, 2013 at 12:12 pm
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?
March 29, 2013 at 12:08 pm
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.
March 29, 2013 at 1:31 pm
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
March 29, 2013 at 1:40 pm
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>
March 30, 2013 at 1:41 pm
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
April 2, 2013 at 1:21 am
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