You got an order from your company CIO, you are asked to design a SQL - ProProfs Discuss
Topics
Products
Follow Us:

You got 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?



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

This question is part of MSBI SSIS Quiz
Asked by LmAkshay, Last updated: Jun 07, 2020

+ Answer
Request

2 Answers

John Adney

John Adney

Answered Sep 27, 2017

An Error output should be added to the Data Flow component

 

John Smith

John Smith

Answered Jan 30, 2017

A Flat File Destination component should be used
An Error output should be added to the Data Flow component

####
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.