May 19 2020 06:14 AM
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 message:
Error: 0xC0202071 with data flow task, SQL Server-T501T [27]: Bulk copying of data not possible. You may need this package execute as administrator.
Any help/hint will be appreciated!
Thank you!
Alexandru
May 20 2020 02:22 AM
SolutionI found the solution in an old ticket on this site:
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.
May 20 2020 02:22 AM
SolutionI found the solution in an old ticket on this site:
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.