Database Reference
In-Depth Information
Figure 7-29
.
ArchiveFile package parameters
Be sure you include default values for an existing folder for the
ArchiveDir-
ectory
parameter and a path to a valid file for the
SourceFilePath
parameter.
For all other parameter default values, use what I have supplied in
Figure 7-29
.
There are a couple ways to design this package. You can rely heavily on scripting
or utilize the File System task. Which should you choose? When consulting, I ask
questions to determine the comfort-level of those charged with maintaining the pack-
ages. Some data integration developers are comfortable with .NET coding; others are
not. Since SSIS gives me a choice, I build packages so they are easily maintained by
the team charged with maintenance.
In this package, I am choosing a hybrid of scripting and the File System task, lean-
ing away from scripting. Let's add the following variables to the package:
•
User::FormattedFileName [String]
•
User::OkToProceed [Boolean]
•
User::SourceFileDirectory [String]
•
User::WorkingCopyFileName [String]
Add a Script task to the control flow and name it
scr Apply Format
. Open the edit-
or and change the
ScriptLanguage
property to Microsoft Visual Basic 2012. Add
the following variables and parameters to the
ReadOnlyVariables
property:
•
System::TaskName
•
System::PackageName
•
$Package::CopyOnly
•
$Package::DateStampFormat
•
$Package::Debug
•
$Package::ExceptionOnFileNotFound
•
$Package::SourceFilePath
Add the following variables and parameters to the
ReadWriteVariables
prop-
erty:
•
User::FormattedFileName
Search WWH ::
Custom Search