Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Kimball ETL Part 1 – Data Profiling via SSIS Data Flow Expand / Collapse
Author
Message
Posted Tuesday, July 22, 2008 11:25 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Comments posted to this topic are about the item Kimball ETL Part 1 – Data Profiling via SSIS Data Flow

Ira Warren Whiteside
Post #538974
Posted Wednesday, July 23, 2008 1:03 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:47 AM
Points: 5,449, Visits: 1,401
Good article... :)


Post #539039
Posted Wednesday, July 23, 2008 12:11 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Uuhhh.......Good read but I admit I am bad at understanding complicated SSIS packages.

SQL DBA.
Post #539553
Posted Wednesday, July 23, 2008 3:38 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:56 AM
Points: 998, Visits: 6,478
Great article Ira, and thnx for the link to the Tod McKenna's blog

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."


Post #539737
Posted Wednesday, July 23, 2008 6:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 10, 2012 6:48 PM
Points: 16, Visits: 76
Great article Ira, what sort of pricing are you looking at for your components?

TIA
Dave
Post #539791
Posted Wednesday, July 23, 2008 6:59 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Dave,

We will be initiating a subscription pricing / flat fee model. My next article will demo how to duplicate the SSIS 2008 Quick Profile Viewer in SSIS 2005 with Excel 2007 as a presentation layer, with eiter the script component or our components. We are finalizing that this week.

We will also be offering several other components as part of a complete Data Quality Solution, Including Data Profiling, Data Cleansing amd Fuzzy Matching. Please send me an email(Contact Us) on www.actualitybusinessintelligence.com and I will send you our proposed pricing.

Thanks,
Ira


Ira Warren Whiteside
Post #539796
Posted Saturday, July 26, 2008 1:52 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 21, 2011 12:17 PM
Points: 103, Visits: 158
Good article, but may I suggest having someone go through and edit it for proper spelling, grammar and clarity? I noticed that the same phrases were repeated one after another and the word "vale" was subplanted for the correct term "value."

Thank you for the knowledge transfer.
Post #541447
Posted Saturday, July 26, 2008 2:03 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
Thanks for the critique, I will do a better job of editing in the next one.

Ira


Ira Warren Whiteside
Post #541449
Posted Saturday, March 14, 2009 10:57 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 11:56 PM
Points: 42, Visits: 291
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


Ira Warren Whiteside
Post #676051
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse