SQL Server 2005 Express - DTS Available?
Posted By : todd sharp Posted At : January 15, 2007 8:46 AM Posted In: SQL
5
I blogged before about using ODBC to import data into an SQL 2005 Express database but I just found a post which claims that the DTS tools are in fact available for users of SQL Server 2005 Express. See the comments in this post, but basically the claim is that SP1 contains the DTSWizard which would be located at "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe". The comments lead me to believe this wizard may have been removed in later editions, but I can not wait to go home and check to see if my version has this. I'm not the biggest fan of DTS, but it can be handy at times.
I think it was removed in later versions.
The DTS import/export wizard appears not to be installed by default.
It's buried in one of the tree-installation diagrams in custom install - open all the branches as the one it is an offshoot of appears to be selected for install...
Unfortunately its dtsrun.exe from sql server 2000, not ssis