April 29, 2008 at 12:46 pm
FROM BOL:
To import a package
Click Start, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
In the Connect to Server dialog box set the following options:
In the Server type box, select Integration Services.
In the Server name box, provide a server name or click and locate the server to use.
If Object Explorer is not open, on the View menu, click Object Explorer.
In Object Explorer, expand the Stored Packages folder.
I don't have a 'Stored Packages folder' .... Does that mean Integration Services is not installe?
April 29, 2008 at 1:02 pm
So you only have a "Running Packages" folder, or you have no folders listed at all in object explorer?
April 29, 2008 at 1:05 pm
I don't have a running packages folder..
in object explorer I have databases, security, server objects, replication, management, and notification services
April 29, 2008 at 1:08 pm
You connected to a Database Engine, not an Integration Services Server.
Go back to your instructions and make sure you follow the step:
'In the Server type box, select Integration Services.'
April 30, 2008 at 8:52 am
THANK YOU!!! As you can see I'm a total newbie with management studio.
I got that far now.. but the problem I'm having is that I am running a Named Instance and NO default Instance so I need to configure the Msdtssrvr.ini.xml file.
Here is my Msdtssrvr.ini.xml and I'm not sure HOW to plug in the instance name????
I thought it would have gone in the 'Servername' line but I can't get it to work???
April 30, 2008 at 9:01 am
Between the ServerName tags replace the period (.) with ServerName\InstanceName
If I remember correctly, the SQLBrowser service has to be running for resolution.
April 30, 2008 at 9:08 am
awesome.. thank you!!!
my correct INI.XML attached!!
SQL Server Browser service is running.
I restarted the SSI Server after changing the INI.XML file. Problem I'm having now is I can't expand Stored Packages in Objext explorer.. I could before I started messing with the INI.XML file and now I can't.. what did I do wrong?
April 30, 2008 at 9:14 am
There is a path in that file - make sure you did not mess it up.
April 30, 2008 at 9:16 am
I attached my file.. see attached. I still can't get integration services to work
April 30, 2008 at 12:32 pm
all set. Thanks for your help
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply