Solved

SQL 2005 Import/Export Package

Posted on 2006-10-27
8
355 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
 
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now