Visual Studio SP1 requirement for SQL Server 2008

SQL Server MVP Phil Brammer has already blogged about the fact that, if you have Visual Studio 2008 installed, you have to install VS 2008 Service Pack 1 before installing SQL Server 2008 "Katmai". Why? Because Katmai contains bits and pieces of SP1, and will refuse to install over VS 2008 RTM. (Just to make life more interesting, Microsoft didn't release VS 2008 SP1 until several days after SQL Server 2008.) You can read a good blog post that summarizes the entire issue, and explains the de... [More]

SQL Server 2008 Feature Pack and Integration Services

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 Feature Pack, especially as they relate to Integration Services: If you have SQL Server 2008, you already have many of the items listed on the Feature Pack page. The only item in the list that's specific to SSIS/DTS is the Microsoft SQL Server 2005 Backw... [More]

64-bit Considerations for SQL Server Integration Services

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, and the costs of localization prevent me from trashing it and starting over. Please see the link for more details on any of the following points. Not much has changed in 64-bit support from SQL Server Integration Services 2005 to 2008. At least you no longe... [More]

Expanded "Feature Selection" page in the SQL Server 2008 Setup Wizard

Just when I thought that I was finally finished with our Setup-related topics! Those wily Setup folks added items to the "Feature Selection" page in the SQL Server 2008 Setup Wizard since I last installed a Katmai build. A couple items need our attention: Client Tools Backward Compatibilty does not install the DTS runtime support. (Please see this post.) Client Tools SDK lays down on disk the managed assemblies needed for Integration Services programming. Otherwise, these assemblies are installed only in th... [More]

DTS support in SQL Server 2008 "Katmai"

[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 for DTS The good news for DTS users is that DTS receives the same degree of support in SQL Server 2008 “Katmai” as in SQL Server 2005 “Yukon”. The bad news is that it’s less convenient (in Katmai) to install that support. Run-t... [More]