Which destination component should you use?

You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data
from a Windows Azure SQL Database database into a SQL Server database.
The SSIS package has the following requirements:
Every night, a very large amount of data is imported into the staging database.
Package processing time must be minimized.
The package must run on its own dedicated server when it is deployed to production.
Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements.
Which destination component should you use?

You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data
from a Windows Azure SQL Database database into a SQL Server database.
The SSIS package has the following requirements:
Every night, a very large amount of data is imported into the staging database.
Package processing time must be minimized.
The package must run on its own dedicated server when it is deployed to production.
Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements.
Which destination component should you use?

A.
Raw File

B.
ODBC

C.
Bulk Insert

D.
OLE DB



Leave a Reply 1

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