dbTalk Databases Forums  

Can not see stored Packages using Management Studio

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Can not see stored Packages using Management Studio in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
TheMask
 
Posts: n/a

Default Can not see stored Packages using Management Studio - 10-04-2006 , 01:25 PM






Hi,

I have a SQL 2005 SP1 running SSIS, when I open the SSIS with SSMS the
"Stored Packages" folder is always empty (I can not see the MSDB and File
system sub-folders) Any idea?



Reply With Quote
  #2  
Old   
Charles Kangai
 
Posts: n/a

Default RE: Can not see stored Packages using Management Studio - 10-05-2006 , 04:26 AM






Assuming you are opening the connection correctly by choosing Integration
Services instead of Database Engine in the Connect to Server dialog of SSMS,
then there may be something wrong with your installation. Check in the folder
C:\Program Files\Microsoft SQL Server\90\DTS\Binn for a file called
MsDtsSrvr.ini.xml. The folders that appear under Stored Packages are listed
in this file. You can also check that the Integration Services service is
running.

One more thing to note: named instances of Integration Services are not
supported at this time although the installation appears to be successful.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk




"TheMask" wrote:

Quote:
Hi,

I have a SQL 2005 SP1 running SSIS, when I open the SSIS with SSMS the
"Stored Packages" folder is always empty (I can not see the MSDB and File
system sub-folders) Any idea?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.