How to use regular expressions on SSIS?

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