- You create a SQL Server 2008 Integration Services R2 (SSIS) package that has a SQL Server Destination component in a Dataflow task.
- You try to run this package on systems where User Account Control (UAC) is enabled (for example, in Windows Vista or in Windows 7) by using one of the following methods:
- Business Intelligence Development Studio (BIDS)
- SQL Server Management Studio (SSMS) Object Explorer
[SSIS.Pipeline] Error: component "SQL Server Destination" failed the pre-execute phase and returned error code 0xC0202071."
Unable to bulk copy data. You may need to run this package as an administrator.
- You do not encounter these errors if you run the package under the built-in Administrator account that is created during operating system installation. But you will receive this message for any other user, including those who are members of the Local Administrators group.
- The problem does not occur when you execute the same SSIS package as a SQL Server Agent job.
- The second error message is generated only after SQL 2008 Service Pack 2 (SP2) is installed.
Note When you use an account that is not a member of local Administrators group, UAC does not appear.
Service pack information for SQL Server 2008 R2To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
This problem was first corrected in SQL Server 2008 R2 Service Pack 1 for SQL Server 2008 R2.
- If you are running the package from SSMS, from BIDS, or from DTExecUI.exe, start those tools from the administrator account. 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. This starts the application by using the elevated permissions of the built in Administrator account, and the package executes successfully.
Similarly if you are running the package by using DTExec.exe, start it from an elevated command prompt. To do this, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
Note If you do not log on to the computer as an administrator, you are prompted to provide the administrator account. In response, type the administrator user name and password in the User Account Control dialog box, and then, click OK.
- Replace the SQL Server Destination components in the Dataflow Tasks that are failing with OLE DB Destination components that point to the same SQL Server connection manager.
- Use an account that is not a member of the local Administrators group after you assign Create Global Objects permissions to that account.
To do this, follow these steps:
- Click Start, point to Administrative Tools, and then click Local Security Policy.
- Expand Local Policies, and then click User Rights Assignment.
- In the details pane, double-click Create global objects.
- In the Local Security Policy Setting dialog box, click Add.
- In the Select Users or Group dialog box, click the user accounts that you want to add, click Add, and then click OK two times.
Artikelnummer: 2216489 – Letzte Überarbeitung: 22.04.2011 – Revision: 1