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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
ASKER
Good
right click the database
select tasks
and Import/export data is near the bottom of the second drop down