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