This is my first Sourceforge release. This is a simple component that can parse text files using a regular expression. It includes a basic UI as well to assist in ensuring that the RegEx will work properly.
To install, download the .dll, copy it to your DTS/PipelineComponents directory, and register it with your GAC using gacutil.exe
Once the dll is installed, open VS.NET or BI studio, and right-click on the toolbar and select 'choose items'. Then select this object from the Pipeline Components tab.
For setup, it must use a File Connection (NOT a flat file connection), and you must specify the regex pattern to use. Each capture () will be returned as a column. If you name captures (?'CaptureName'), that name will be shown as the column name. All columns are returned as varchar(8000). The first column is always the complete row.
To Do:
- Allow nested captures which will require multiple outputs.
- Create an .msi package
- Create documentation
As I mentioned, this is my first SourceForge release, so I am interested in feedback. I created this for another project, and it seemed quite useful to me, so I figured others might find it so as well.