SQL Server 2005 Express - DTS Confirmed

Posted By : todd sharp Posted At : January 16, 2007 12:37 PM Posted In: SQL

6

As a quick follow up to yesterdays post, I have confirmed that the DTS Wizard that us SQL Server 2000 users know and love is in fact available for use with SQL Server 2005 Express. Go here and download the Microsoft SQL Server 2005 Express Edition Toolkit SP1. Install the tools and hit C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe and you'll get the good old Import/Export Wizard. You can also associate the wizard as a 'Tool' within SQL Server Management Studio Express which saves you a little time when you need to import/export. Unfortunately you still can not directly select an object and import/export but the fact that you can still use the tool makes me happy.

16333 Views Send Print Comments (6)

Related Blog Entries

Comments (6)

Subscribe to Comments Add Comment

Christian Ready's Gravatar That's great news! I uninstalled SQL Server 2005 because of an apparent lack of DTS support. That said, all of my remote SQL Server databases are still 2000. I wonder if it's considered "safe" to use SQL Server 2005 locally then?

Posted by: Christian Ready on: 1/16/07 1:56 PM

todd sharp's Gravatar That I do not know. Do you mean for local dev environment? If so the only reason I can think of for not doing so would be any functionality that may exist in 2005 that couldn't be used in 2000. I'd hate to write a proc on 2005 that wouldn't work when I pushed it into production.

Posted by: todd sharp on: 1/16/07 2:06 PM

Christian Ready's Gravatar Thanks Todd. I think my databases are fairly straightforward - a number of tables linked by primary and forgien keys. No stored procs or anything like that. So I might try SQL 2005 locally and use it to connect to my remote production SQL 2000 machines.

Then again, if the system works fine as is (e.g., using 2000), why change?

Posted by: Christian Ready on: 1/16/07 2:10 PM

Sridhar's Gravatar Thanks for the Info. How do I can schedule this DTS Package using the SQL
Express

Posted by: Sridhar on: 1/19/07 12:34 AM

Dmitriy's Gravatar Maybe this tool can be helpful too... Read there http://www.aspnetcafe.com/post/2007/12/HOWTO-Get-C...
Helps to make complete SQL dump of tables structure and data.

Posted by: Dmitriy on: 12/21/07 5:00 AM

Shyokou Ouyou's Gravatar Sorry I am too late ;-)

As if the SQL Server Express Edition dropped classic DTS from 2005, say, a couple of docs addressed you have to install the 2000 compatibles for classic DTS; anyhow, from SP1 (at least to SP3) to 2005 you may "accidently" have DTS Wizard installed if you previously configured your 'Microsoft SQL Server 2005 Tools' properly, e.g., with the 'Business Intelligence Development Studio' component (aka 'setup.exe ADDLOCAL=SQL_WarehouseDevWorkbench' if you prefer the command line) ...

If you were NOT lucky enough to have the 'Business Intelligence Development Studio' component installed with 'Microsoft SQL Server 2005 Tools' like me, and see nothing by the name 'Microsoft SQL Server 2005 Tools' in 'Add/Remove Programs', you may have to rely upon the registry, since a key SystemComponent=dword:00000001 prevents it from showing up; try to either temporarily remove this key, or run 'MsiExec.exe /I{7B59F8B5-A9DD-4162-BFB4-5A48F0958F91}' alternatively, you then have another chance to check the box by the name ''Business Intelligence Development Studio' and have your DTS Wizard as expected ...

Posted by: Shyokou Ouyou on: 8/31/09 11:10 PM
Add Comment

  • Calendar

    << March 2010 >>
    Sun Mon Tue Wed Thu Fri Sat
     123456
    7 8 9 10 11 12 13
    14 15 16 17 18 19 20
    21 22 23 24 25 26 27
    28 29 30 31    

  • Subscribe

    • Enter your email address to subscribe to this blog.