Hi everyone, Is it possible? I haven't idea how to implement as if it were done from conventional .Net code I'd like to check every field for a plan file First field NNNNNNN Second field XXXNNNNNNN ,, Thanks for any input or idea,

You can use a script task ; an example of using here About the second part of question an ideea can come from here.

This transform may also be of use - http://www.sqlis.com/91.aspx

Thanks indeed to both. It's useful.

Hi Darren, Regarding your link about Regular Expressions tasks, unfortunately, third-components are not allowed in our environment...

enric vives wrote: Hi Darren, Regarding your link about Regular Expressions tasks, unfortunately, third-components are not allowed in our environment... That's uunfortunate!

I appreciate many organisations think that way. I would be interested in knowing why that is the case for you? What would it take to allow such component usage in your organisation? I'd be happy to see what could be done to help people like youself in these situations. Do you not use any non-MS products? If you are intertested then I'd be happy to discuss this further or offline, mail me darren dot green at konesans com

I would like to share the new Melissa Data SSIS Total Data Quality Toolkit TDQ-IT, including SSIS Data Profiling 2005/2008 including Regulra Expressions. 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 organizations data quality and master data management (MDM) initiatives. Request a free trial today. http://www.melissadata.com/dqt/total-data-quality-integration.htm

I have written a regular expression component for SSIS that greatly simplifies using regexes in data flows. You can specify a regular expression to operate on any text column and the captured matches of that regex get output to new columns. The main use is to extract data that is buried in text, but some have used it for validating fields (like email address formats).The SSIS component is free and open source. You can get it at: http://regextractor.codeplex.com Hope this helps (I realize I'm late in my response) Eric

Here are two C# Script Component examples that use .Net Regular expressions. - To validate (for example an email address): http://microsoft-ssis.blogspot.com/2011/03/regular-expressions-in-ssis.html - To replace/remove values (for example remove html tags): http://microsoft-ssis.blogspot.com/2011/03/cleaning-with-regular-expressions-in.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com