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 and maximizing data flow performance.
What should you do?
A.
Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it.
B.
Use an SSIS Script transformation that uses the custom assembly to parse the text data when
inserting it.
C.
Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to parse
the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data.
D.
Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly
to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting
data.
The answer should be B in v2?
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.
Thanks
shouldn’t it be Script transformation as it is used by data flow. ans should be A.