You work as a database administrator at You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for The SSIS instance uses a default connection manager to connect to a component. You develop an XML configuration file to provide the required authentication information for your report. However, you receive an error message stating that you are unable to log in successfully to the package. You need to ensure that the package is able to run normally. What should you do?

1)You should consider modifying the XML configuration file.

2)You should consider using direct XML settings.

3)You should consider executing the package as the component on the same server.

4)You should consider using a .REG file that contains all log entries.

  • : 325
  • : 15
    Previous Next

    You should consider modifying the XML configuration file.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence

    Recommended Learning for you

    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material