Make the most of SQL Server Integration Services Script Components

Melissa sponsored on-demand webinar

Webcast Abstract

SQL Server Integration Services (SSIS) has become the defacto standard for moving data in Microsoft shops. Although moving data is generally possible with the data flow components, sometimes scripting is necessary to address particular requirements. Unfortunately, SSIS Script Components can be complex and unlike typical .NET projects in Visual Studio have limitations due to architectural differences. Overcoming these obstacles can be time consuming and error prone. Itís not uncommon for developers to make use of third party libraries, APIs, and Web Services in their applications or scripts. Doing so in SQL Server Integration Services poses some challenges and limitations. Moreover, some data transformations require asynchronous processing of data which are otherwise unachievable through a synchronous serial process.

In this webinar, you will learn:

  • Architecture behind SSIS Script Components
  • Issues behind third party library consumption in SSIS Script Components
  • How to successfully setup and run third party libraries in SSIS Script Components
  • Asynchronous processing in SSIS Script Components and the associated advantages
  • And more

We will also learn about a solution from Melissa on how to ease your SQL Server data management directly in Integration Services.

Speaker - Meelad Vahdat

Meelad Vahdat is a Sales Engineer at Melissa Global Intelligence.

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

get free sql tips
agree to terms