Migrating From DTS to SSIS - Part 1

In this presentation, Brian talks about the good, the bad, and the ugly of DTS migrations. Then, he shows you how to migrate a simple DTS package to SSIS and some of the challenges you will see.

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.

Modi, Sanjay on 2/4/2009

very useful information please keep it up Sanjay Modi

Fred Zimmerman on 2/11/2009

I'm brand new to DTS and SSIS so this skimmed over material and did it very quickly. Maybe more toward audience of knowledgeable SSIS or DTS developers. Wasn't sure which video to start with here to learn SSIS fresh from list shown.

Sam on 2/12/2009

Useful

M Hoss on 2/19/2009

Great start. Where would be the other parts in this multipart video?

shiv kasi on 3/15/2009

excellent

pablo on 7/20/2009

great video, but i will like see it in action. www.naranjaweb.com www.gmobilesys.com

shaun on 7/22/2009

Nice video. where can i get the other parts in this multipart series?

vnarayanaraju on 11/24/2009

Please tell slowly

Jason P. on 1/5/2010

Interesting, I need to migrate several DTS packages to SSIS and this was helpful.

Paul Davis on 2/3/2010

It would be nice if you grouped these videos as "beginning topics", "intermediate topics" and "advanced topics" or something so that people new to SSIS had a good idea of which videos to watch first.

harishkumar127 on 4/7/2010

Thank you

Zafar Khan on 4/15/2010

where are the other parts please

Deepesh on 4/24/2010

Other parts yeah.

Nithin on 11/10/2010

Very good tutorial for DTS to SSIS migrations. Please post the remaining parts

Jim on 4/13/2011

could have used more detail about the source dts package being converted - especially the dynamic properties

T. Carnahan on 9/21/2011

A little too fast. When he clicks on things, it would be helpful to have him say he is doing it. Some of the dialog boxes pop up and the view has no idea of where they came from.