What should you do?

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system. Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes. You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.

What should you do?
A . Add a data tap on the output of a component in the package data flow.
B . Deploy the package by using an msi file.
C . Run the package by using the dtexecui.exe utility and the SQL Log provider.
D . uses the dtutil /copy command.
E . Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
F . Create an OnError event handler.
G . uses the Project Deployment Wizard.
H . Use the gacutil command.
. Create a reusable custom logging component.
. Run the package by using the dtexec /rep /conn command.
. Run the package by using the dtexec /dumperror /conn command.

Answer: A

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments