Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

SQL Server DTS - viewing transformations

We have a DTS package that has a very large number of transformations in it. The DTS designer displays these as a huge number of little lines that are almost impossible to work with (looks almost like a barcode at this point). Is there another way to view these transformations, or is there a 3rd party tool that anyone knows about that we could use to make this a bit more user-friendly?
[389 byte] By [cgoodyear] at [2008-1-10]
«« error registrated COM object as MULTI-THREADED COM SERVER DLL
»» Focus box for radio button
# 1

Have you tried using the view | zoom feature? Sounds like you have the view zoomed quite small so that all transforms are visible. With finite designer space, on large dataflow layouts you must choose between viewing a few transforms and their details vs. viewing all the transforms with little detail or something in between.

KirkHaselden at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2
Thanks, this helped. We also just found that we could right click on the main transformation, select one of the tables and then choose the task we wanted to edit from the properties dialog.
cgoodyear at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified