Sunday, June 8, 2008

Import/Export data with SQL Server 2005 Express - DTS Wizard


After using the simple sql server 2005 data transfer utility for some days I thought to add more functionality such as import export data from excel, CSV, flat file etc.

Before start coding I just did a Google search and found this big and interesting discussion in MSDN forums. In the first page developers were really annoyed with the fact MS is not giving a data transfer utility with Sql Server Management Studio Express.

I read the conversation one by one and in the 5th page I found this posting by Bill Elicson. MS actually has a really great DTS tool for sql server management studio express.

Thanks Bill.. you saved alot of time.

STEPS TO ADD DTS WIZARD WITH SQL SERVER MANAGEMNT STUDIO EXPRESS

1. Try "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
If it worked, you already have the DTS Wizard. Start using it right away.

If it will not work, continue to step 2

2. Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) from

http://go.microsoft.com/fwlink/?LinkId=65111
select all components to install

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

Thats it.. Now you can transfer data using the the great DTS wizard.

Follow the steps If you want to integrate it with the Sql server management studio express UI .
1. Open sql server management studio express.
2. Select Tools -> External Tools
3. Add a Title and Browse C:\Program Files\Microsoft SQL Server\90 \DTS\Binn\DTSWizard.exe for the Command field.
3. Click OK

TAGS
Importing Exporting Data sql server express,sql server express data transfer, dts sql server express, sqlserver express DTS, move data sqlexpress 2005, SQLEXPRESS 2005 to SQL 2000 Data Transfer, Data import/export with SQL Server Express using DTS Wizard, Data Transfer between SQL Server and SQL Server Express

15 comments:

Anonymous said...

I'm glad I found this. It's exactly what I needed, a simple explanation.

Thanks for posting.

rahardi said...

Thanks, after i change dtswizard.exe only,my dts can working again.i can continuou my job now.

rahardi said...

Thanks, after i change dtswizard.exe only,my dts can working again.i can continuou my job now.

Anonymous said...

Can't install the toolkit. It says, none will be upgraded.

Here is the details:

Name: Microsoft SQL Server 2005 Tools
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

I have SQL 2005 Express SP2.

prabhakar said...

Great,Thanks for such valuable information.

david said...

Great suggestion!!! thk a lot
David

Anonymous said...

HUGE Thanks. You have saved me a lot of work.

Anonymous said...

Very nice! Thanks!
To make it easier, you can also add this executable to the MS SQL Server Management Studio Express thru the External Tools under Tools menu.

Julio said...

Perfect stuff dude, I was banging my head to the wall but finally found the light.

frentemahou.blogspot.com

Julio said...

Exactly what I was looking for, this is going to save me loads of time and a more than sure headacke.

Cheers mate

frentemahou.blogspot.com

lifeinasia said...

I tried adding it to the Toolbar, but get the following error when I click on it:
Value does not fall within the expected range. (Microsoft.SqlServer.Express.SQLEditors)

magols said...

Thanks!! I was looking for this because the import/export wizard wasn't doing what I wanted. I don't see why MS doesn't put this in the start menu but instead hides it...

cochonutz said...

i prefer to use tool such as E.M.S. SQL MANAGER
you can download it here :
http://depositfiles.com/files/pv2agxhri

Rehan Sheikh said...

Thank you very much. It'a very useful post.

Simon said...

Similar problems to some noted above. On selecting all components, the install just says 'None of the selected features can be installed or upgraded. Setup cannot proceed since no effective changes is being made to the machine....'
And no DTSWizard.exe is to be found anywhere.... annoying.

Search

Google