In response, type the administrator user name and password in the User Account Control dialog box, and then, click OK. Note If you do not log on to the computer as an administrator, you are prompted to provide the administrator account. To do this, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator. Similarly if you are running the package by using DTExec.exe, start it from an elevated command prompt. This starts the application by using the elevated permissions of the built in Administrator account, and the package executes successfully. To do this, click Start, point to All Programs, point to SQL Server 2005 or SQL Server 2008, right-click the tool that you are using, and then click Run as administrator. If you are running the package from SSMS, from BIDS, or from DTExecUI.exe, start those tools from the administrator account. To work around this problem, use one of the following methods: This problem was first corrected in SQL Server 2008 R2 Service Pack 1 for SQL Server 2008 R2. 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)
