Microsoft
70-463 · Question #186
70-463 Question #186: Real Exam Question with Answer & Explanation
The correct answer is C: Execute the package by using the 32-bit run-time option.. See step 3 below. To publish an Excel worksheet to Azure SQL Database, your package will contain a Data Flow Task, Excel Source task, and ADO NET Destination. 1) Create an SSIS project. 2) Drop a Data Flow Task onto the Control Flow design surface, and double click the Data Flow
Question
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been deployed to a production server that runs Windows Server 2008 R2 and SQL Server 2012. The package fails when executed on the production server. You need to ensure that the package can load the Excel workbook data without errors. You need to use the least amount of administrative effort to achieve this goal. What should you do?
Options
- ACreate a custom SSIS source component that encapsulates the 32-bit driver and compile it
- BInstall a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
- CExecute the package by using the 32-bit run-time option.
- DReplace the SSIS Excel source with a SSIS Flat File source.
Explanation
- See step 3 below. To publish an Excel worksheet to Azure SQL Database, your package will contain a Data Flow Task, Excel Source task, and ADO NET Destination. 1) Create an SSIS project. 2) Drop a Data Flow Task onto the Control Flow design surface, and double click the Data Flow 3) Drop an Excel Source onto the Data Flow design surface. Note When using the Excel Source task on a 64-bit machine, set Run64BitRuntime to False. Not D: The Flat File source reads data from a text file. The text file can be in delimited, fixed width, or mixed format.
Community Discussion
No community discussion yet for this question.