Which two actions should you perform?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The OLE DB data source for the package is a database that is updated frequently.

You need to create a package that accomplishes the following tasks:

Implement the IRowsetFastLoad interface.
Support various data flow destinations.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The OLE DB data source for the package is a database that is updated frequently.

You need to create a package that accomplishes the following tasks:

Implement the IRowsetFastLoad interface.
Support various data flow destinations.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A.
Use an OLE DB data flow destination.

B.
Use a Recordset data flow destination.

C.
Use a DataReader data flow destination.

D.
Create separate data flow destinations within the same Data Flow task.



Leave a Reply 0

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