asked on What Happened to the DTS GUI
I have built hundreds of DTS packages with an interface that has task, connection, source, destinations objects, with drag and drop for these objects onto a package where I could easily (well usually easily) build a mapping of columns and occasionally some custom VB script for formatting the imported data. I have downloaded the "DTS for SQL 2005" and it seems like it is an import/export wizard, and my GUI interface for building and manipulating packages/data objects is gone.
If anyone can explain or point me in the right direction, I would greatly appreciate it.
Thanks,
Howard
If anyone can explain or point me in the right direction, I would greatly appreciate it.
Thanks,
Howard
Microsoft SQL ServerMicrosoft SQL Server 2005
Last Comment
Howard Bash
ASKER
I tried that prior to starting this thread. At the end of all that, I had a new Tool available "DTS" and it looks nothing like the DTS GUI that I have used in the past and looks more like a simple import/export wizard.
In the "OLD" days, I could drag and drop objects onto a package display, connecting dependent tasks with branching on successful and unsuccessful results. Is it somewhere buried within this "DTS" tool that the above URL adds?
Thanks.
In the "OLD" days, I could drag and drop objects onto a package display, connecting dependent tasks with branching on successful and unsuccessful results. Is it somewhere buried within this "DTS" tool that the above URL adds?
Thanks.
ASKER
Weareit, I have tried the suggested install and it only enables a data import/export wizard. Do you have any other suggestions here?
Thanks,
Howard
Thanks,
Howard
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
-saige-