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.

SSIS Stumpers V1 - Unpivot Example

In this series, Brian Knight shows you an actual difficult business problem to solve, gives you hints about how to solve it and then lastly shows you step-by-step instructions how to solve it if you want the help. You can download the sample code for this at http://www.endtoendtraining.com/private/misc/downloads.aspx. In this video of the series, Brian shows you how to unpivot data that may arrive from the mainframe and load a many to many table with SSIS.

Video Information
Publish Date:	June 27, 2007
Length:	13:30
Skill Level:	400
Rating:	4.61 out of 5

You must be logged in to view this video.

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

Comments:

suresh on 8/11/2008

how can i download this video

jayant on 9/13/2008

at first register, and then u an downlooad via download link in menu

David Branscome on 10/1/2008

very good sample, samples passing variables would be nice to.

Chris Rock @ JumpStartTV.Com on 10/1/2008

David, Click on the "Suggest a video" link at the top of this page to suggest the video you would like to see!

Christopher Quinn on 10/3/2008

Good walk through, just wish the work space was larger so that we could see the whole package at once.

Rupesh on 10/4/2008

Excellent work! Thanks a lot for such a nice tutorial.

Jon Sommervold on 10/7/2008

Excellent!

raja on 10/19/2008

very good

Bijay on 11/3/2008

Excellent Tutorial

archana on 11/30/2008

too good

Emile on 12/9/2008

Excellent

Michael Prendergast on 12/29/2008

Excellent use of the Derived Column Transformation

Mallikarjun on 1/27/2009

Excellent example for Unpivot data, too good

Dan on 2/14/2009

Excellent example

tavis on 4/6/2009

great walk through

Henko on 8/10/2009

Thanks Bryan, for helping out on the unpivot transform!

Michael Flora on 10/2/2009

Awesome!

Chinna Chowdary on 12/21/2009

It's Informative

Tonci on 12/30/2009

Unpivot process looks not easy, but you explain its generalties very well. Thank you.

Neelam on 1/2/2010

great v.

Priyadarshan Patil on 1/10/2010

plz shows some example related to mainframe and SSIS

Sol on 1/22/2010

ayuda, ayuda por favor como puedo bajar este video

cevahir begen on 1/31/2010

excellent work!. Request: some short videos should combine. dont worry we can visit your side any time but time is important for everyone !


Must Be Logged In

References

Download the Stumper Document, Code and Data

Download the SSIS Stumpers document, the sample code and the data.

SSIS Training

4 Day SSIS class taught by Brian.