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

weareit

Download and install the Microsoft SQL Server 2000 DTS Designer Components from this page:

http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

-saige-

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.

Howard Bash

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

ASKER CERTIFIED SOLUTION

Howard Bash

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial