Instead of
the project if you were to highlight the package and double-click on it, there will be
a drop-down menu as shown in the next screenshot:
Chapter 2
[ 51 ]
This has a wealth of information. You can execute the package from here by just
choosing the Execute Package option. If everything is working correctly, you should
be able to successfully execute the package. From here, you can see the code or the
designer depending on your choice. The package file is an XML document, which
you see when you choose View Code, consisting of two tasks that are not configured
as yet.
Creating a BI Project for SSIS in Visual Studio 2005
[ 52 ]
xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:ExecutableType="MSDTS.Package.1">DTS:Name="PackageFormatVersion">2DTS:Name="VersionComments">DTS:Name="CreatorName">HODENTEK\JayDTS:Name="CreatorComputerName">HODENTEKProperty DTS:Name="CreationDate" DTS:DataType="7">6/5/2007
11:04:42 AMDTS:Name="PackageType">5DTS:Name="ProtectionLevel">1"MaxConcurrentExecutables">-1DTS:Name="PackagePriorityClass">0Name="VersionMajor">1DTS:Name="VersionMinor">0DTS:Name="VersionBuild">1DTS:Name="VersionGUID">{B391A52D-01A3-44FA-8E81-AC70B672E6D6}DTS:Property>DTS:Name="EnableConfig">0DTS:Name="CheckpointFileName">DTS:Name="SaveCheckpoints">0DTS:Name="CheckpointUsage">0DTS:Name="SuppressConfigurationWarnings">0
DTS:DataType="8">
DTS:Name="CreationName">OnErrorDTS:Executable>
You may even choose to exclude this package from the solution and focus
on another.
Pages:
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58