SQL 2005 Import/Export Package

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
KimberleyYAsked:
Who is Participating?
 
gpompeConnect With a Mentor Commented:
You have to enter the sever and the intance where you have Installed SSIS in the form of computername\instancename
0
 
gpompeCommented:
I usually get saved as DTS package (SSIS in 2005) on the same server.
0
 
gpompeCommented:
That by default and if you checked off the box to save it.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
KimberleyYAuthor 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
0
 
gpompeCommented:
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
 
KimberleyYAuthor 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
------------------------------
0
 
KimberleyYAuthor 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
------------------------------
0
 
KimberleyYAuthor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.