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?…

Question

Options

• AModify the Flat File Destination.
• BModify the log provider.
• CMove the package file to the new path.
• DModify the Connection Manager.

• A
  13% (3)
• B
  83% (19)
• C
  4% (1)

Explanation

B: The SQL Server log provider, which writes log entries to the sysssislog table in a SQL Server 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. Not A: The destination is a SQL Server database, not a text file.

No community discussion yet for this question.