Database Reference
In-Depth Information
Return to the
Parent.dtsx
package and change the value of the
ChildPack-
agePath
variable, substituting
Child2.dtsx
for
Child1.dtsx
. Execute
Par-
ent.dtsx
in the SSDT debugger and observe the results, as shown in
Figure A-6
.
Figure A-6
.
Executing Child2.dtsx in the parent-child pattern
Pretty cool, huh? We're just getting started!
Let's create a database to hold package metadata. Open SQL Server Management
Studio (SSMS) and execute the T-SQL script shown in
Listing A-2
.
Listing A-2
.
Creating the SSISConfig Database
Use master
go
/* SSISConfig database */
If Not Exists(Select name
From sys.databases
Where name = 'SSISConfig')
begin
print 'Creating SSISConfig database'
Create Database SSISConfig
print 'SSISConfig database created'
Search WWH ::
Custom Search