September 2006 - Posts

Thinking of Going to Vista, Be Careful!

If you currently run SQL Server of MSDE on your desktop, you need to really be careful before migrating to Windows Vista. It has been announced that Windows Vista will only support SQL Server 2005 SP2 (yet to be released) and above. SQL Server 2000 and 7.0 will no longer be support. Is this going to slow support of Windows Vista. I can't help but to think it might for many enterprises that run MSDE on their desktop.

-- Brian

Transactions in SSIS How To Video

In this SSIS demonstration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.

Using Transactions in SSIS (watch the video)

Brian Kngiht

Looping through a ADO Resultset in SSIS How-to Video

A while ago I write a quick post on how to loop through an ado recordset in ADO. It seems to be a common question on the newsgroups so I decided to produce a how to video on how to loop through an ADO recordset in SSIS.


Author: Knight, Brian
Description: In this video, you'll learn how to use the For Each ADO enumerator to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client


New Database Snapshot and Integration Services Series on JumpstartTV

I've created a few new videos last night for One video gives you an overview of this cool database high availability feature in SQL Server 2005 and then the next video shows you how you can integrate snapshots into SSIS. Registration is required on the site but it's free.

Description: In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.
Description: Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
-- Brian