Link to home
Start Free TrialLog in
Avatar of billyboy71
billyboy71

asked on

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

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.
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image

do you mean  SSIS?

right click the database
select tasks
and Import/export data is near the bottom of the second drop down
ASKER CERTIFIED SOLUTION
Avatar of rboyd56
rboyd56

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
Avatar of billyboy71
billyboy71

ASKER

Good