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.mi...
Comments