2

We know that there is no out of feature for Regular expression in SSIS. We came to know that we need to write .Net script in custom Script transformation. However, we would like to write Java method for this, could any help us whether SSIS can support this if support how can I can call this method in SSIS.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Prasad Kada
  • 63
  • 7
  • 1
    If you can write a Java library or .dll , you should be able to import it into the c# script with the using statement like most other external librarys you can import into c# scripts. – Brad Mar 21 '19 at 12:53
  • 1
    @Prasad based on https://www.purplefrogsystems.com/blog/2011/07/pattern-matching-in-ssis-using-regular-expressions-and-the-script-component/ this is not a limitation. A one liner to import RegEx `using System.Text.RegularExpressions;` But using Java methods is a long and complicated unnecessary road to go in my view. – Arthur Mar 21 '19 at 14:26

1 Answers1

1

Why using Java while there are easier solutions to implement??

(1) Flat File Regex source

If you are looking to use Regular Expression on a Flat File Source, then you can benefit from the Flat File Regular Expression Source created by Microsoft community:

(2) Regex within Scripts

Also if you are looking to implement regular expression inside Script Task or Script Component you can benefit from the System.Text.RegularExpression library which is apart from the .Net Framework. THere are plenty of tutorials found online:

(3) Regular expression transformation

Also there are some third part Regex transformation components:

Helpful articles

Hadi
  • 36,233
  • 13
  • 65
  • 124