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…

Question

Options

• AUse an SSIS Script task that uses the custom assembly to parse the text data when
• BUse an SSIS Script transformation that uses the custom assembly to parse the text data
• CCreate a SQL Common Language Runtime (SQLCLR) function that uses the custom
• DCreate a SQL Common Language Runtime (SQLCLR) stored procedure that uses the

• A
  80% (28)
• B
  11% (4)
• C
  6% (2)
• D
  3% (1)

Explanation

This question also contains a mismatch between its stem and answer choices. The stem asks about connecting SSIS to a Windows Azure SQL Database instance using a project parameter for the address across multiple packages with minimal effort and maximum performance - a scenario best addressed by a project-level OLE DB connection manager whose ConnectionString property is mapped to a project parameter. However, the answer choices describe Script task or SQLCLR approaches for parsing text data with a custom assembly, which are unrelated to the stated problem. The listed correct answer A is 'Use an SSIS Script task with a custom assembly to parse text data,' which does not align with the question stem. This is a question bank pairing error; the choices belong to a different question about custom text parsing.

No community discussion yet for this question.