Execution Patterns - SQL Server Integration Services Design Patterns - page 96

Again, this code merely points to the Helper module, in this case
frmISTreeHelper . Add a new module, so named, and replace it with the following
code:
'
' frmISTreeHelper module
'
' I use a Helper Pattern when developing interfaces.
' Each form is named frm_____ and there is
a corresponding module named frm_____Helper.vb.
' Each event method calls a subroutine in the Helper
module.
'
' This module supports frmISTree.
'
Imports Microsoft.SqlServer.Management.IntegrationServices
Imports Microsoft.SqlServer.Management.Smo
Module frmISTreeHelper
' variables
Public sFullSSISPkgPath As String
Sub frmISTreeInit()
' initialize and load frmISTree
With frmISTree
.Text = "Integration Services"
.txtServer.Text = "localhost"
.ShowDialog()
End With
End Sub
Sub btnConnectClick()