We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

SQL 2005 Import/Export Package

KimberleyY
KimberleyY asked
on
Medium Priority
384 Views
Last Modified: 2008-01-09
From the SQL Server Management Studio I created and saved an import/export package using the wizard.  The problem is - how do I run it again and where is it saved to?

Thanks in advance.
Kim
Comment
Watch Question

Commented:
I usually get saved as DTS package (SSIS in 2005) on the same server.

Commented:
That by default and if you checked off the box to save it.

Author

Commented:

I did check the box to save it and when I try to save it again with the same name it says it already exists - so the save did work.  

How (what do I need to click on) do I run it again -
and where (*c:\????) does it get saved to

Kim

Commented:
You have to connect to the integration service, that probably is running in the box as the DB.

To do this, press the connect button in the object explorer and select integration services...

Author

Commented:
When trying to connect to integration services I get the following message - I have more than one instace of SQL Server (small business installs an instance instead of using the one that is there) - SO based on the message below - I think I need to "define a default instance" - how do I do that? (Notice i ncreased the points!)

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The SQL server 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 Service" in Server 2005 Books Online.

Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2].  (MsDtsSrvr)

------------------------------
BUTTONS:

OK
------------------------------
Commented:
You have to enter the sever and the intance where you have Installed SSIS in the form of computername\instancename

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I get SSIS to open, however when I click on MSDB I get the message above.  when I try to connect to intergartion services using computername/instatnace name I get the fgollowing message:

TITLE: Connect to Server
------------------------------

Cannot connect to ACCESS-SERVER\Gateway.

------------------------------
ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

Invalid server name "ACCESS-SERVER\Gateway". SSIS service does not support multi-instance, use just server name instead of "server name\instance".


------------------------------

Invalid server name "ACCESS-SERVER\Gateway". SSIS service does not support multi-instance, use just server name instead of "server name\instance".


------------------------------
BUTTONS:

OK
------------------------------

Author

Commented:
Thanks gpompe -
I gave you a good since your refernece to server name instance name gave me a clue but didnt tell me HOW TO do that (which I really needed to know)

- With your clue and my error messages I searched SQL Server Help for "SSIS Default Instance" an came up with the following llnk

http://msdn2.microsoft.com/en-us/library/ms137789.aspx

This explained HOW TO to change the default "server name \ instance name" - once i followed these instructins and stopped and restarted the serive I could then find my import / export package

Thanks
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.