Skip to main content

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

Labels:

Comments

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

Thanks for posting.
February 20, 2009 at 1:15 PM
Admin said…
Thanks, after i change dtswizard.exe only,my dts can working again.i can continuou my job now.
May 11, 2009 at 8:42 PM
Admin said…
Thanks, after i change dtswizard.exe only,my dts can working again.i can continuou my job now.
May 11, 2009 at 8:44 PM
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.
June 1, 2009 at 9:16 PM
prabhakar said…
Great,Thanks for such valuable information.
June 3, 2009 at 9:48 AM
Dylan@66 said…
Great suggestion!!! thk a lot
David
June 17, 2009 at 5:56 AM
Anonymous said…
HUGE Thanks. You have saved me a lot of work.
June 22, 2009 at 6:00 PM
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.
July 8, 2009 at 8:38 PM
kunta said…
Perfect stuff dude, I was banging my head to the wall but finally found the light.

frentemahou.blogspot.com
July 27, 2009 at 1:18 AM
kunta 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
July 27, 2009 at 1:21 AM
Unknown 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)
August 18, 2009 at 3:02 PM
Unknown 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...
November 30, 2009 at 4:37 PM
cochonutz said…
i prefer to use tool such as E.M.S. SQL MANAGER
you can download it here :
http://depositfiles.com/files/pv2agxhri
December 7, 2009 at 5:51 PM
Unknown said…
Thank you very much. It'a very useful post.
December 15, 2009 at 4:17 AM
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.
February 19, 2010 at 9:01 AM
Post a Comment

Popular posts from this blog

Asp.Net CAPTCHA and Asp.Net AJAX CAPTCHA

I am using a great Asp.Net CAPTCHA by BrainJar in a number of web sites with and without Asp.Net AJAX. It’s a simple and really easy to use Asp.Net CAPTCHA. The actual source code is in C#, but you can use it with both C# and VB.Net by simply wrapping the functionality in a class library. In Asp.Net forums and in many other user communities I have seen lot of people asking for VB.Net CAPTCHA. So I thought to write a blog post and create some sample implementations. The zip file contains C# CAPTCHA and VB.Net CAPTCHA. I have included the samples for Asp.Net AJAX CAPTCHA also. You can download the samples and implementation from here Implementing Asp.Net AJAX CAPTCHA is really simple. Just wrap the main Asp.Net CAPTCHA with Asp.Net AJAX update panel and put a random query string at the end of CAPTCHA image src. The random query string will avoid showing the old CAPTCHA from browser cache. STEPS TO ADD ASP.NET CAPTCHA IN YOUR WEBSITE Refer the assembly CaptchaDLL.dll in your project Copy...
23 comments
Read more

Simple Numeric Pagination for DataList and Repeater

There are a big number of tutorials available on how to implement pagination in asp.net DataList and Repeater. But all of them are explaining only about the Next/Prev mode of pagination only. Recently I have implemented a quick and dirty numeric pagination on DataList for one of my project. The idea is simply use a PagedDataSource to get the current page of data and bind it to DataList or Repeater. Now create dynamic Linkbuttons using the PageSize and the Total rows count. See the code below. ASPX Code <head runat="server"> <title>Untitled Page</title> <style type="text/css"> .pagination a{padding:5px;} .pagination span{padding:5px;} </style> </head> <body> <form id="form1" runat="server"> <div> <asp:DataList ID="dlPaginationSample" runat="server"> <ItemTemplate> <%# Eval("Column1")%> | <%# Eval(...
10 comments
Read more