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
why not bulk insert??
I have the same question.
The reason don’t use the Bulk Insert Task is you need a transformation or any other Data Flow Task. But by question it is not required.
Which DESTINATION component should be used? Bulk Insert is not a destination component; it’s a data loading technique (sort of, a Data Transform, at best).
Moreso, OLE DB offers the best connection mode to an SQL database.
+10
I LIKE slazenjer_m’s EXPLANATIONS MOST OF THE TIME.
you do noting but agree with ppl!!
D
Not C – because Buk Insert is for flat files
didto
Agreed with previous comments the correct answer is D
Bulk Insert task can transfer data only from a text file into a SQL Server table or view according to MSDN, checkout this link;
https://msdn.microsoft.com/en-us/library/ms141239(v=sql.110).aspx