Forum Discussion

Alexandru1190's avatar
Alexandru1190
Copper Contributor
May 19, 2020
Solved

Error: 0xC0202071 with data flow task... You may need this package execute as administrator

Hello,   in my environment with SQL Server 2019 CU4 using SSIS in Visual Studio, I try to load a flat file to a table in SQL Server.   The data flow task is erroneous: I got following error messa...
Integration Services(SSIS)
  • Alexandru1190's avatar
    Alexandru1190
    May 20, 2020

    I found the solution in an old ticket on this site:

     

    https://support.microsoft.com/en-ie/help/2009672/you-may-get-unable-to-prepare-the-ssis-bulk-insert-for-data-insertion

     

    If you are running the package from either SQL Server Management Studio (SSMS) or Business Intelligence Development Studio (BIDS) or DTExecUI.exe, launch those tools under the elevated Administrator account. To do this, click Start , point to All Programs , point to Visual Studio , right-click the tool you are using and then click Run as administrator. This launches the application with elevated privileges of the Built In Administrator account and the package executes successfully.

Alexandru1190's avatar
Alexandru1190
Copper Contributor
May 20, 2020

I found the solution in an old ticket on this site:

 

https://support.microsoft.com/en-ie/help/2009672/you-may-get-unable-to-prepare-the-ssis-bulk-insert-for-data-insertion

 

If you are running the package from either SQL Server Management Studio (SSMS) or Business Intelligence Development Studio (BIDS) or DTExecUI.exe, launch those tools under the elevated Administrator account. To do this, click Start , point to All Programs , point to Visual Studio , right-click the tool you are using and then click Run as administrator. This launches the application with elevated privileges of the Built In Administrator account and the package executes successfully.

Resources