You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now you get an order from your company CIO, you are asked to design a SQL Server 2008 Integration Services (SSIS) package.
The package contains a Data Flow task. According to the requirement of the company CIO, the package has to be modified to write all rows by which errors are generated to a text file.
So what should you do? (choose more than one)
A.
A Flat File Destination component should be used
B.
A Raw File Destination component should be used
C.
The SSIS log provider for the SQL Profiler should be used
D.
An Error output should be added to the Data Flow component
E.
The SSIS log provider for the text file should be used