Solved

MS SQL Server Enterprise Manager Had DTS but SQL Server Management Studio Express Does Not???

Posted on 2008-06-18
3
714 Views
Last Modified: 2013-11-30
MS SQL Server Enterprise Manager Had DTS but SQL Server Management Studio Express Does Not.  How can I get Data Transformation Services for Studio Express?  I have tried installing a DTS setup that was supposed to work, but it only gives me an import/export wizard and no DTS with a GUI plus all the other goodies.

Please advise.

Thanks,
Howard
0
Comment
Question by:Howard Bash
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 21812291
No ETL tools come w/ the express versions.
0
 
LVL 1

Author Comment

by:Howard Bash
ID: 21812523
I have been googling about this and there are lots of links that claim to add DTS to this version.  They all run (or at least don't indicate a failure), but do not provide DTS.
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 21812564
I've not seen any DTS or SSIS tools that come w/ the Express version.  Here is a link from MS on it:
http://msdn.microsoft.com/en-us/library/ms365247.aspx
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question