How are variables created and
initialized? Explain metadata in regards to SSIS:
Variables are created by right click inside the control
flow , then click the variables->Then we see a variable window where we can
create a variable, declare the variable with the data type and initialize the
variable by giving the value of variables.
METADATA
Metadata simply means
data with in a data. For example if there is an employee table then metadata
can be ‘This table includes the employee list of the company ‘ But In
SSIS , we used Derived
Column transformation, a developer can add a column or columns to the data
transformation process based on variables or expressions. The values of these
variables or expressions can be set during the execution process, and can
include technical metadata such as the file name of the source of the data row,
the date/time of the processing, or the name or ID of the Integration Services
package that transformed the data. We can show how the Derived Column
transformation can be used to read technical metadata about the package and use
that metadata in an audit. For example, we can audit the version of the package
that was executed, and when the package was run. Here the metadata being
audited includes the creator, build version, major version, minor version, and
source file name.
No comments:
Post a Comment