Browse by Tags

Find the top Knowledge Base articles for DTS

Published 17 March 9 3:26 PM | dougbert

Here are the top Microsoft Support Knowledge Base articles that SQL Server Data Transformation Services (DTS) customers have been reading. You may find them useful also. This time I've simply sorted the list from most viewed to least view, for the...

Filed under: DTS, known issues

Design DTS packages reliably on Windows Server 2008 and Vista

Published 16 December 8 11:42 AM | dougbert

Yesterday (Monday, Dec 15, 2008) Microsoft released Service Pack 3 for SQL Server 2005 . This release includes an update to the Feature Pack, which includes the DTS Package Designer components for use with SQL Server 2005 Integration Services and SQL...

Filed under: DTS

SQL Server 2008 Feature Pack and Integration Services

Published 2 July 8 1:14 PM | dougbert

Bloggers (like my pal Buck Woody on his Carpe Datum blog ) are mentioning the SQL Server 2008 Feature Pack . The so-called Feature Pack is a Web page that lists many individual downloads related to SQL Server 2008. Here are some of the features of the...

Filed under: setup, DTS, 2008

Speaking of writing Office XML...

Published 21 June 8 1:17 PM | dougbert

In my third installment on Excel issues , I proposed writing out Excel XML rather than binary Excel files as one way to avoid both the issues of the Excel driver, and the risks of Excel automation. Recently I came across a DTS custom task that I wrote...

Filed under: DTS, Excel, XML

64-bit Considerations for SQL Server Integration Services

Published 10 June 8 10:31 AM | dougbert

Herewith my best effort to restate the contents of the Books Online topic, 64-bit Considerations for Integration Services , more simply and cleanly. Unfortunately the BOL topic has become quite messy over time, as one bandage is applied over another,...

Filed under: setup, DTS, 64-bit

DTS application properties

Published 26 May 8 1:41 PM | dougbert

There's a dialog box of DTS application-wide settings that disappeared from SQL Server 2005 and 2008. It used to live on the context (right-click) menu of the DTS node in SQL Server 2000 Enterprise Manager. One day in a moment of spare time I set...

Filed under: DTS, source code

DTS support in SQL Server 2008 "Katmai"

Published 28 April 8 7:15 PM | dougbert

[REVISED WITH ADDITIONAL INFORMATION SAT 5/24/08, MON 5/27/08, MON 10/13/08] It may seem ironic to start a new blog by talking about old stuff. But we all loved DTS in our youth, and it’s been a popular subject in my Inbox lately. Run-time support...

Filed under: setup, DTS, 2008