Which component should you use?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB05, which hosts the SQL Server 2008 Integration
Services (SSIS) and has a Data Flow task.
The CIO has informed you to make sure that the package logs errors to a Microsoft Word
document. You then decide to add an Error output to the source component.
Which component should you use?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB05, which hosts the SQL Server 2008 Integration
Services (SSIS) and has a Data Flow task.
The CIO has informed you to make sure that the package logs errors to a Microsoft Word
document. You then decide to add an Error output to the source component.
Which component should you use?

A.
A Flat File Result component.

B.
A Flat File Destination component.

C.
A Data Source component.

D.
A Flat File Source component.

E.
A Common Data Flow component.



Leave a Reply 0

Your email address will not be published. Required fields are marked *