Speaker

Matija Lah

Matija Lah

Mi Lambda, Matija Lah, s.p.

Ljubljana, Slovenia

Actions

Matija Lah has more than twenty years of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award between 2007 and 2017/2018 (Data Platform). He spends most of his time on projects involving advanced information management, and natural language processing, but often finds time to speak at events related to Microsoft SQL Server where he loves to share his experience with the SQL Server platform.

Area of Expertise

  • Law & Regulation
  • Information & Communications Technology

Microsoft SQL Server Integration Services: Custom Data Flow Components

SQL Server Integration Services provide you with a set of Data Flow components that implement the most common operations in data extraction, transformation, and integration. If your specific situation calls for a solution that is not provided natively, you can also use the Script Component to embed your custom logic in the given SSIS package. However, in order to use such customisations in more than one package, it is recommended to design Custom Components instead.

In this session you will learn how to leverage the functionalities provided in the managed Data Flow Pipeline assemblies to design a custom data flow component that behaves as if it was one of the natively provided ones.

More specifically, you will learn how to implement Regular Expressions in an SSIS data flow to extract additional data from one or more columns in the pipeline and place it back into the pipeline as additional columns.

The session covers SSIS functionalities that have been available in SQL Server since version 2012.

Data Saturday Holland Sessionize Event

October 2019 Utrecht, The Netherlands

KulenDayz 2019 Sessionize Event

September 2019 Osijek, Croatia

Matija Lah

Mi Lambda, Matija Lah, s.p.

Ljubljana, Slovenia

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top