Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:Ģ527041 How to obtain the latest service pack for SQL Server 2008 R2 Status To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. Resolution Service pack information for SQL Server 2008 R2 Note When you use an account that is not a member of local Administrators group, UAC does not appear. By default, SSIS always uses the low-permissions token, and this causes a failure when SSIS connects to a SQL Server Destination component. The elevated-permissions token is used only when the application is explicitly run under an administrator account by using the Run as Administrator option. When an application (such as SSIS) is started by an account that is a member of the Administrators group, it receives two security tokens: a low-permissions token and an elevated-permissions token. This issue occurs on systems where UAC is enabled. The second error message is generated only after SQL 2008 Service Pack 2 (SP2) is installed. The problem does not occur when you execute the same SSIS package as a SQL Server Agent job.
But you will receive this message for any other user, including those who are members of the Local Administrators group. You do not encounter these errors if you run the package under the built-in Administrator account that is created during operating system installation. You may need to run this package as an administrator. Error: component "SQL Server Destination" failed the pre-execute phase and returned error code 0xC0202071." Error: Unable to prepare the SSIS bulk insert for data insertion.
0 kommentar(er)
