|
Comments:
|
|
good
|
|
|
content is good but voice quality is very poor.
|
|
|
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.
|
|
|
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
|
|
|
can you please post the code for download?
|
|
|
Good!! I did not have any prob with the audio
|
|
|
Great video.. but I could not download the "Code"..Can you please make it available
|
|
|
very informative
|
|
|
Can't download source code
|
|
|
How do I download the sourcecode? The code download link takes me to an invalid page.
|
|
|
You mentioned several sites for help with script code, and stated you would post them.
|
|
|
where is the code man?
|
|
|
Please upload the code soon.
|
|
|
Good job!
|
|
|
Where can I get the source code for this video?
|
|
|
no code available
|
|
|
good
|
|
|
I found the CODE!!! I know its late, but I just started working with data profiling via 2005:
Microsoft SQL Server Integration Services user script component
' This is your new script component in Microsoft Visual Basic .NET
' ScriptMain is the entrypoint class for script components
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain
Inherits UserComponent
Dim patAlphaUpper As String = "[^a-z0-9 ,@%&/#'.-]"
Dim patAlphaLower As String = "[^A-Z0-9 ,@%&/#'.-]"
Dim patNum As String = "[^A-Za-z ,@%&/#'.-]"
Dim patSpecial As String = "[^A-Za-z0-9]"
Dim patEmail As String = "\b[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}\b"
Dim patUSPhone As String = "^(?:(?<1>[(])?(?<AreaCode>[1-9]\d{2})(?(1)[)])(?(1)(?<2>[ ])|(?:(?<3>[-])|(?<4>[ ])))?)?(?<Prefix>[1-9]\d{2})(?(AreaCode)(?:(?(1)(?(2)[- ]|[-]?))|(?(3)[-])|(?(4)[- ]))|[- ]?)(?<Suffix>\d{4})$"
Dim rgxAlphaUpper As New Text.RegularExpressions.Regex(patAlphaUpper)
Dim rgxAlphalower As New Text.RegularExpressions.Regex(patAlphaLower)
Dim rgxSpecial As New Text.RegularExpressions.Regex(patSpecial)
Dim rgxNum As New Text.RegularExpressions.Regex(patNum)
Dim rgxEmail As New Text.RegularExpressions.Regex(patEmail)
Dim rgxPhone As New Text.RegularExpressions.Regex(patUSPhone)
Dim tagAlphaUpper As String
Dim tagAlphaLower As String
Dim tagNumber As String
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
'
' Add your code here
'
Row.EmailLength = Len(Row.EmailAddress)
tagAlphaUpper = rgxAlphaUpper.Replace(Row.EmailAddress, "A")
tagAlphaLower = rgxAlphalower.Replace(tagAlphaUpper, "a")
Row.EmailPattern = rgxNum.Replace(tagAlphaLower, "9")
Row.EmailFlag = rgxEmail.Match(Row.EmailAddress).Success
Row.PhoneLength = Len(Row.Phone)
Row.PhoneFlag = rgxPhone.Match(Row.Phone).Success
tagAlphaUpper = rgxAlphaUpper.Replace(Row.Phone, "A")
tagAlphaLower = rgxAlphalower.Replace(tagAlphaUpper, "a")
Row.PhonePattern = rgxNum.Replace(tagAlphaLower, "9")
Row.Count = 1
End Sub
End Class
|
|
|
Sorry, the copy and paste didn't work like I thought it would. here's the link of the script code from the video:
http://www.sqlservercentral.com/articles/Extract%2c+Transform%2c+Load+(ETL)/63792/
If you have a SQLServerCentral.com account, in the search bar copy and paste:
Kimball ETL Part 1 – Data Profiling via SSIS Data Flow
the first article will be the entire article and video of this method. Hope this helps!
|