Search the Knowledgebase Browse by Category
      Home       Web Hosting       Web Hosting Guide       MsSQL Management
   Importing data into MsSQL 2005 Database

The Microsoft Data Transformation Services (DTS) is provided in the SQL Server Express with Advanced Services SP2 Toolkit. The installation will provide an additional DTS folder in C:\Program Files\Microsoft SQL Server\90\ .

The Importing can be done using the Import/Export wizard provided by C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

However there is no tool created in the Management studio for the same. You can add an external tool by using Tools >> External Tools and adding the path to DTSWizard.exe in the Command field.

And now you are ready to use Import Export wizard in MsSQL 2005 Express Edition.


Live Support

If you have any questions at all, please don't hesitate to contact us

+91.22.28663101, 66789456

To submit Support ticket, click here


     Related FAQs
What Servername & Port do I use to connect to MsSQL Database ?
Using MsSQL DTS for database management
Importing data into MsSQL 2005 Database
Exporting data from MsSQL Database