Can we download the DTS Designer?

I am using SQL Server Express 2005 CPT April, and I would like to use the DTS Designer with it. I have been looking for a download but have not found it yet. Does anyone know where I can download it from or if DTS Designer is included in the tools that come with SQL Server Express? I haven't gotten those tools working yet.

ThanksIf you mean the Integration Services (we renamed for SQL Server 2005) then no it can not be downloaded for use with Express(this is the same story as MSDE in 2000). You should download the Developer, Std or Ent SKUs from June as the IS designer is part of each of these.

-Euan

Can Query Designer Handle Subqueries`

When a subquery is part of an insert, update or just a from or where clause, it doesn't seem to have a way to structure it. Is there a procedure for that?

Thanks,

DavidHi David -
The only structuring functionality for your scenario is to use the block indent/unident function. You can find these menu items/shortcuts under the Edit menu.

Michael Raheem
Program Manager
SQL Server Tools Team|||Hi David,
One other alternative starting with the APril CTP is to use the query designer within the Query Editor to design each sub-query by selecting the text to design and then issuing the Design Query in Editor command.
Thank you,
Bill Ramos