Hello

I have this pattern that I want to use to match parts of the string to the
(city, state zip_code) pattern. I know that it works outside of DTS but when
I try to use it in my DTS package I get this error
---------------------------
<DTS Testing Transform Task>
---------------------------
The number of failing rows exceeds the maximum specified.
Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Syntax error in regular expression


here is the code


PATTERN="(?n[A-Z]([a-z])+(\.?)(\x20[A-Z]([a-z])+){0,2})\,\x20(A[LKSZRAP]|C
[AOT]|D[EC]|F[LM]|G[AU]|HI|I[ADLN]|K[SY]|LA|M[ADEHINOPST]|N[CDEHJMVY]|O[HKR]
set RegExpCityStateZip = new RegExp
RegExpCityStateZip.Pattern = PATTERN

addr3 = TRIM( DTSSource("Col007") )
if ( addr3 ) <> "" Then
set Matches = RegExpCityStateZip.Execute( addr3 ) ' It fails on this
line
If Matches.Count > 0 Then
' the rest of the code is here

end if
end if

Any Ideas why would it fail

Thank you

David

"David Kleyman" <test (AT) hotmail (DOT) com> wrote




You could try removing the clause "Set Options to Explicit Capture" (
in other words delete this substring '?n:' from your
pattern).
If you try your original pattern frm VB 6 you should get an error like

'Error 5017 :Application-defined or object-defined error'

so i think it's not a matter of DTS.