Author:

Author Bio:

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

Integrating Database Snapshots into Integration Services

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.

Video Information
Publish Date:	September 28, 2006
Length:	10:30
Skill Level:	300
Rating:	4.03 out of 5

Watch Video Now! Watch it later!

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

ouchene on 8/29/2008

verry good presentation for this example

jayant on 9/19/2008

very useful

Sachin Kainth on 10/24/2008

Not his best movie. The video was a bit jumpy and not always in sync with the audio. It's hard undeerstanding his accent sometimes. He didn't explain some things well enough like the table he was talking about at the beginning of the video. He also went quitefast through some steps.

mehmet on 1/2/2009

Thanks Brian!

Travis on 3/6/2009

I love Brian Knight as an author. I have many of his books and can't say enough about his expertise. However, his speaking ability really lacks a lot. He talks way too fast and his voice almost has a lisp to it making him very hard to understand...

zhong chen on 3/8/2009

it is very useful

Raalnan Five on 4/8/2009

You should point out that Standard editions of SQLS don't include snapshot ability.

nick on 2/9/2010

that was cool brian. keep uploading..


Must Be Logged In

References

SSIS Training

4 Day SSIS class taught by Brian.

Sample package

The package code used in this video.