You work as a database administrator at Abc.com. Abc.com network contains a development database server named ABC-DB06 and a production database server named TESCKLING-DB01. You are creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You include ABC-DB06 in the SSIS package. You publish the package to ABCDB06 but discover that you are not able to move the data between ABC-DB06 and ABC-DB01. You receive the following error message: The package could not link to ABC-DB06. You need to modify the package to reference the ABC-DB06 when it is implemented. What should you do?
1)You need to change the features of the package in order to use the DontSaveSensitive package protection level. 2)You need to change the features of the package in order to use the store procedure. 3)You need to select the Connection Manager check box on the Connection Managers tab of the Execute Package utility and then change the connection string. 4)You need to add to the expression on the Flat File Connection manager prior to modifying the connection string. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at firstname.lastname@example.org
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