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 ««12

I cannot import SSIS package into MSDB folder. Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 12:08 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:37 AM
Points: 154, Visits: 685
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.
Post #1437044
Posted Friday, March 29, 2013 1:31 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 13,357, Visits: 10,221
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1437070
Posted Friday, March 29, 2013 1:40 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:37 AM
Points: 154, Visits: 685
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>
Post #1437076
Posted Saturday, March 30, 2013 1:41 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 13,357, Visits: 10,221
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.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1437234
Posted Tuesday, April 2, 2013 1:21 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:18 AM
Points: 559, Visits: 1,159
Are you sure your account has the correct ssisadmin permissions on msdb on that server?
Post #1437726
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse