Solved

Where is the DTS Import/Export Wizard on SQL Server 2005?

Posted on 2007-04-10
4
487 Views
Last Modified: 2012-08-13
I am trying to import an Access 2003 Database into my SQL Server 2005.  However, there is no Enterprise Manager with SQL Server 2005 Evaluation version. I downloaded the SQL Server Management Studio Express and it does not have any import function in it.

Thanks.
0
Comment
Question by:billyboy71
4 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 18883697
do you mean  SSIS?

right click the database
select tasks
and Import/export data is near the bottom of the second drop down
0
 
LVL 16

Accepted Solution

by:
rboyd56 earned 250 total points
ID: 18883700
The SQL Server 2005 Evaluation Edition should have Management Studio with it. Did you install teh Workstation components when you ran setup?

I do not know where it is in the Express Edition of Management Studio, but in the version that comes with SQL Server 2005 you get to the Import Wizard by right clicking on the Management folder under the SQL Server tree.
0
 
LVL 27

Expert Comment

by:ptjcb
ID: 18884139
SQL Server Integration Services is not available in SQL Server 2005 Express Edition.

You should check your installation for the SQL 2005 Enterprise Evaluation edition. Did you select the Integration Services on the Components to Install page of the installation wizard?

Do you have Visual Studio installed? Have you started a VS project and selected SQL Server Integration?
0
 

Author Comment

by:billyboy71
ID: 18890653
Good
0

Featured Post

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.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

813 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

11 Experts available now in Live!

Get 1:1 Help Now