Solved

SQL 2005 Import/Export Package

Posted on 2006-10-27
8
360 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
0
Comment
Question by:KimberleyY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 9

Expert Comment

by:gpompe
ID: 17820257
I usually get saved as DTS package (SSIS in 2005) on the same server.
0
 
LVL 9

Expert Comment

by:gpompe
ID: 17820268
That by default and if you checked off the box to save it.
0
 

Author Comment

by:KimberleyY
ID: 17820308

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
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 9

Expert Comment

by:gpompe
ID: 17820805
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...

0
 

Author Comment

by:KimberleyY
ID: 17821286
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
------------------------------
0
 
LVL 9

Accepted Solution

by:
gpompe earned 250 total points
ID: 17821620
You have to enter the sever and the intance where you have Installed SSIS in the form of computername\instancename
0
 

Author Comment

by:KimberleyY
ID: 17821792
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
------------------------------
0
 

Author Comment

by:KimberleyY
ID: 17825361
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
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question