You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
According to the requirement of the company CIO, you are using SQL Server 2008
Integration Services (SSIS) to create packages.
The package connects to a third-party database server by using an OLE DB connection
manager.
Integrated Windows authentication is not supported by the database.
A configuration file is created to configure the connection manager. The configuration file is
added to the package after it is created.
An error message pops up when the package executes.
The error message says that the login step fails. Now you must solve this problem.
So what should you do to successfully execute the package?
A.
In order to achieve this goal, you should use an indirect XML configuration
B.
In order to achieve this goal, you should edit the XML configuration file
C.
In order to achieve this goal, you should use a Microsoft ADO.NET connection manager
while not an OLE DB connection manager
D.
In order to achieve this goal, you should run the package on the same server as the thirdparty database server