Database Reference
In-Depth Information
The Demo Application
For this demonstration, I used Visual Basic 2013 and the .NET Framework 4.5.1. I
downloaded a copy from www.microsoft.com/en-us/download/de-
tails.aspx?id=40787 . Unless otherwise specified, I accepted the default settings
for VB applications in the Visual Studio 2013 Integrated Development Environment
(IDE).
To begin, create a new VB Windows Forms project in Visual Studio 2013. Add ref-
erences for the following assemblies:
Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.DTSRuntimeWrap
Mi-
crosoft.SqlServer.Management.IntegrationServices
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo
You will have to search for Mi-
crosoft.SqlServer.Management.IntegrationServices and Mi-
crosoft.SqlServer.SMO in the global assembly cache (GAC). The GAC is loc-
ated in the Windows\Assembly folder, and these libraries are in the MSIL folder. Click
Browse when adding references to the Visual Studio project.
The frmMain Form
Rename Form1 to frmMain . Add two GroupBox controls to the form, arranged with
one over the other as shown in Figure 2-9 . Change the Text property of the top group
box to SSIS Package in the File System and the Text property of the lower group box
to SSIS Package in the Catalog. In the upper group box, add a label, text box, and two
buttons. Change the Text property of the label to Package Path. Name one of the but-
tons btnOpenSSISPkg and change its Text property to “...”. Name the other button bt-
nStartFile and set its Text property to Start .
 
Search WWH ::




Custom Search