You develop a SQL Server 2008 Integration Services (SSIS) package.
You need to modify the package to log event data from a text file to the SQL Server
database.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)
A.
Modify the Flat File Destination.
B.
Modify the log provider.
C.
Move the package file to the new path.
D.
Modify the Connection Manager.
Explanation:
B: The SQL Server log provider, which writes log entries to the sysssislog table in a
SQL Server database.
D: A package typically includes at least one connection manager. A connection manager is a
link between a package and a data source that defines the connection string for accessing
the data that the tasks, transformations, and event handlers in the package use. Integration
Services includes connection types for data sources such as text and XML files, relational
databases, and Analysis Services databases and projects.
Note: A log is a collection of information about the package that is collected when the
package runs. For example, a log can provide the start and finish time for a package run. A
log provider defines the destination type and the format that the package and its containers
and tasks can use to log run-time information. The logs are associated with a package, but
the tasks and containers in the package can log information to any package log. Integration
Services includes a variety of built-in log providers for logging. For example, Integration
Services includes log providers for SQL Server and text files. You can also create custom
log providers and use them for logging.
Incorrect:
Not A: The destination is a SQL Server database, not a text file.
References: Integration Services (SSIS) Packages