Installing Import/Export Wizard for SQL Express

Where do I install the necessary files to get the import/export wizard to show up in sql express management studio? I have tried installing the SP1 Toolkit, the advanced services etc but I cannot get it so that I can right click on a database and 'import data' or 'export data'

Thanks!

I am not sure but because Management studio express is for express database which does not support SSIS services and SQL agent which are used for export/import by wizard this option was removed from user interface.

Sorry

|||

It does not show up on the UI but I found it in this directory

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I think it comes with the Toolkit download

Tony

Installing 2nd (Named) Instance of SQL Server 2005 EE

When installing a 2nd instance of SQL Server 2005 EE on a server, is it
necessary to install Reporting Services, SSIS, and Analysis Services again?
Does anyone know of any good documentation that discusses this subject?
Thanks.Thanks. Appreciate the prompt reply.
"Gilberto Zampatti" wrote:
> No, if you need just an OLTP and / or olap named instance, you don't have to
> reinstall RS or AS; you cannot install a second instance of SSIS because SSIS
> is a stand alone service and you cannot have two SSIS on the same server.
> The first documentation you have to read is the setup documentation;
> Gilberto
> "MACason" wrote:
> > When installing a 2nd instance of SQL Server 2005 EE on a server, is it
> > necessary to install Reporting Services, SSIS, and Analysis Services again?
> > Does anyone know of any good documentation that discusses this subject?
> >
> > Thanks.|||No, if you need just an OLTP and / or olap named instance, you don't have to
reinstall RS or AS; you cannot install a second instance of SSIS because SSIS
is a stand alone service and you cannot have two SSIS on the same server.
The first documentation you have to read is the setup documentation;
Gilberto
"MACason" wrote:
> When installing a 2nd instance of SQL Server 2005 EE on a server, is it
> necessary to install Reporting Services, SSIS, and Analysis Services again?
> Does anyone know of any good documentation that discusses this subject?
> Thanks.sql