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