You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) instance for Abc.com. 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. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at email@example.com
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us