DTS in MSSQL 2005 - Important

1 view
Skip to first unread message

NEO

unread,
Jun 4, 2008, 1:46:40 AM6/4/08
to orangescape.dimension
Important: if you have Microsoft SQL Server Management Studio Standard
edition you do not need to do this setup and you should be able to
export your database to our server using the DTSwizard, if you have
sql 2005 express edition please read the following information:

To export a database created in ms sql 2005 express edition you must
download the Microsoft SQL Server 2005 Express Edition Toolkit which
include the DTSwizard to export and import database between sql server
2005:

http://www.microsoft.com/downloads/details.aspx?familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

Direct link: http://go.microsoft.com/fwlink/?LinkId=65111

Once is installed follow these steps to execute the DTS wizard to
transfer the database from your source to our sql server:

- Go to the folder installation of Microsoft SQL Server 2005 Express
Edition Toolkit to execute DTSwizard. In an standard installation it
will be on:

C:\Program Files\Microsoft SQL Server\90\DTS\Binn

- click DTSWizard.exe

The wizard will start asking for your SQL server source and you should
be able to complete the following steps successfully.
Reply all
Reply to author
Forward
0 new messages