you can use script component and use the following code :

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Imports System.Windows.Forms

Public Class ScriptMain

Inherits UserComponent

Public Overrides Sub...