PrepAway - Latest Free Exam Questions & Answers

You need to establish the best technique to log these invalid rows while keeping the amount of development eff

You are implementing a SQL Server Integration Services (SSIS) package that loads data
hosted in a SQL Azure database into a data warehouse.
The source system contains redundant or inconsistent data. When the package finds invalid
data, the row containing the invalid data must be omitted but it must also be written to a text
file for further analysis.
You need to establish the best technique to log these invalid rows while keeping the amount
of development effort to a minimum.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Add an OnError event handler to the SSIS project.

B.
Open a command prompt and execute the package by using the SQL Log provider and
running the dtexecui.exe utility.

C.
Use an msi file to deploy the package on the server.

D.
Open a command prompt and run the gacutil command.

E.
Run the dtutil command to deploy the package to the SSIS catalog and store the
configuration in SQL Server.

F.
Open a command prompt and run the dtutil /copy command.

G.
Create a reusable custom logging component and use it in the SSIS project.

H.
Configure the SSIS solution to use the Project Deployment Model.

I.
Configure the output of a component in the package data flow to use a data tap.

J.
Open a command prompt and run the dtexec /rep /conn command.
K.
Open a command prompt and run the dtexec /dumperror /conn command.

Explanation:
http://technet.microsoft.com/en-us/library/hh230989.aspx
http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html
http://msdn.microsoft.com/en-us/library/ms162820.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
http://technet.microsoft.com/en-us/library/ms140223.aspx
http://msdn.microsoft.com/en-us/library/jj655339.aspx

3 Comments on “You need to establish the best technique to log these invalid rows while keeping the amount of development eff

  1. John Sno says:

    I am divided on this one. A data tap writes all data to a csv file, not just the error data.
    And you cannot configure it to omit invalid data.
    OnError eventhandler will let you configure the task to do whatever you want but will not dump the error data to a csv file.
    So the question is just poorly formulated.




    0



    0
  2. henrov says:

    I agree with John Sno. The requirement to _omit_ the error data but _write it to a text-file_ almost suggests a custom component despite the ‘ keeping development to a minimum’.
    Anyone can explain this?




    0



    0

Leave a Reply