SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Ira W Whiteside
Author:

Author Bio:
Ira Whiteside and Pragmatic Works will partner with you or your company to make your DTS migration project a success. They have a number of approaches based on how much experience and time you have to complete your project. They will help you formulate a low-risk plan to make your project a success by blending our unique experience with your team.
Data Profiling in SSIS

Data Profiling in SSIS

In this presentation, Ira shows you how to data profile in SSIS using a Script transform and some creative methods like RegEx. He shows you how to look for patterns in your data to find bad data that wouldn't be obvious to the eye or casual viewer.

Video Information
Publish Date:
May 01, 2007
Length:
9:23
Skill Level:
400
Rating:
3.94 out of 5

You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
shank on 10/24/2008
good

mpadigela on 1/2/2009
content is good but voice quality is very poor.

Ira W Whiteside on 1/3/2009
Mahipay, Sorry to hear that, I do not seem to have that problem. If you have any questions you can contact me iwhiteside@iwhiteside.com.

Ira W Whiteside on 3/14/2009
I would like to share the new Melissa Data SSIS Total Data Quality Toolkit TDQ-IT, including SSIS Data Profiling 2005/2008. Melissa Data SSIS Total Data Quality Toolkit TDQ-IT offers a wide range of data transformation and cleansing functionality including data profiling, parsing, cleansing, matching and monitoring functionality built right in to SSIS. And, TDQ-IT leverages SSIS to provide a flexible, effective solution for your organization’s data quality and master data management (MDM) initiatives. Request a free trial today. http://www.melissadata.com/dqt/total-data-quality-integration.htm

shaun on 7/22/2009
can you please post the code for download?

Marsaline on 8/25/2009
Good!! I did not have any prob with the audio

Alok on 9/11/2009
Great video.. but I could not download the "Code"..Can you please make it available

Dean Gross on 9/15/2009
very informative

Joe Qian on 10/13/2009
Can't download source code

E2A1214606 on 11/23/2009
How do I download the sourcecode? The code download link takes me to an invalid page.

Stephen on 12/24/2009
You mentioned several sites for help with script code, and stated you would post them.

nick on 2/6/2010
where is the code man?

absher786 on 2/9/2010
Please upload the code soon.

Jay on 3/6/2010
Good job!



Must Be Logged In

References
Brian's Newest SSIS Book

4 Day SSIS class taught by Brian.

Download the code example from this webcast.

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions