Is It Possible To Create A Class Library That I Can Import Inside Script Components In My Package?

Good day everyone,


I have a package that loads data from a flat file, performs some transformations and then inserts the final data into a DB destination. The keys for the different DB records are generated in Script components in the Data Flow Tasks.


My question is concerning the Key Generation and I'll try to explain it on a simple example.


Package Structure:

The Control Flow contains two Data Flow tasks.
Each of the Data Flow Tasks contains a Script Component responsible for generating the keys of the records to be loaded during this data flow.


The code of the Script component is the following:



Code Block
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class KeyGenerator

' Field Definitions '
Private seed1 As Integer
Private seed2 As Integer

' Constructor '
Public Sub New(ByVal dbSeed1 As Integer, ByVal dbSeed2 As Integer)
.....
End Sub

' Generates the keys according to the seeds retrieved from the DB '
Public Function getNextKey() As Int64
...
...
Return generatedKey
End Function

End Class


Public Class ScriptMain
Inherits UserComponent

Private generator As New KeyGenerator(7, 5)

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

....
Row.NewKey = generator.getNextKey()

End Sub
End Class






Questions:
As you can see the KeyGenerator class code gets duplicated in each Script Component, which is definitely a bad practise. What I wish to do is to create the KeyGenerator class and deploy it as a library "somewhere". Then, in each Script Component, I should only import the KeyGenerator class.


1. Is that possible?

2. If yes, how can I do this?

3. If not, what is a best practise you would recommend which allows me to avoid this code duplication of the KeyGenerator class?


Thanks in adavance,
Samar