-
http://www.amazon.com/gp/product/0470247959/ Professional Microsoft SQL Server 2008 Integration Services by SQL Server MVPs Brian Knight and Erik Veerman, our own broadly smiling Grant Dickinson, and industry experts Douglas Hinson and Darren Herbold At this writing, US $31.49 on Amazon.com and in stock...
-
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...
-
No, this isn't my first religious posting! We're talking about the SQL Server Import and Export Wizard , which was built upon Data Transformation Services (DTS) in SQL Server 2000, and is now built upon Integration Services in SQL Server 2005 and 2008. Some users have complained that the new...
-
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...
-
Hey, someone finally told those Marketing folks that there's something other than coffee mugs and polo shirts! But I wasn't expecting...US postage stamps! Sure enough, now you can mail your bill payments with a SQL Server 2008 stamp... Click the Microsoft link at this URL . You'll notice...
-
The SQL Server 2008 Books Online page in which we describe the steps for upgrading and redistributing custom components is now live: Upgrading Custom Objects for SQL Server 2008 Integration Services This topic is for shops that wrote a custom component for SQL Server 2005 Integration Services, and who...
-
[UPDATED WITH A BETTER CODE SAMPLE FOR THE 2ND SCENARIO TUE 6/10/08] The move in SQL Server 2008 Integration Services from VSA to VSTA for scripting doesn't just give us C# and a better IDE and Add Reference dialog. It has also made programmatic manipulation of the Script task easier and more supportable...
-
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...
-
THIS LIMITATION HAS BEEN FIXED AND REMOVED FOR SQL SERVER 2008 RTM. Object of any type can now be passed through package variables of type Object, and consumed within Script task code. No, wait. Maybe it's "My Object doesn't like my Variable." Anyway, we just had to remove one of the...
-
There are no big surprises in the breakdown of Integration Services features by edition for SQL Server 2008 "Katmai". A couple of notes... The Import and Export Wizard is now included with SQL Server Express. The new Data Profiling Task and Data Profiling Viewer are included in Standard edition...
-
To supplement the current version of the list that's here in BOL, here are some additions or corrections to the list of custom properties of data flow components whose values can be set by using an expression in SQL Server 2008 "Katmai": ADO Source (formerly DataReader Source) SqlCommand...
-
[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...