You are developing a SQL Server Integration Services (SSIS) project to read and write data
from a Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of
the target Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of
administrative effort.
What should you do?
A.
Add a SQLMOBILE connection manager to each package.
B.
Add an ADO.NET project connection manager.
C.
Add a SQLMOBILE project connection manager.
D.
Add an ADO.NET connection manager to each data flow task.
E.
Add a SQLMOBILE connection manager to each data flow task.
F.
Add an ADO.NET connection manager to each package.
Right answer is B
“The address of the target Windows Azure SQL Database database will be provided by a project parameter”, still you’d rather add connection manager to each package?!
SQLMOBILE Connection Manager is utilized by SQL Compact Edition to enable package deployment. The SQL Compact destination specified by the SSIS package, includes using this type of connection manager to load data into a table in the SQL Server Compact database.
Option B is the right answer.