Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2005 Import/Export Package

Posted on 2006-10-27
8
Medium Priority
?
373 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
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

581 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