SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1402358%22%20slang%3D%22en-US%22%3EError%3A%200xC0202071%20with%20data%20flow%20task...%20You%20may%20need%20this%20package%20execute%20as%20administrator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHello%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Ein%20my%20environment%20with%20SQL%20Server%202019%20CU4%20using%20SSIS%20in%20Visual%20Studio%2C%20I%20try%20to%20load%20a%20flat%20file%20to%20a%20table%20in%20SQL%20Server.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThe%20data%20flow%20task%20is%20erroneous%3A%20I%20got%20following%20error%20message%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EError%3A%200xC0202071%20with%20data%20flow%20task%2C%20SQL%20Server-T501T%20%5B27%5D%3A%20Bulk%20copying%20of%20data%20not%20possible.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EYou%20may%20need%20this%20package%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eexecute%20as%20administrator.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EAny%20help%2Fhint%20will%20be%20appreciated!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThank%20you!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EAlexandru%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1402358%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegration%20Services(SSIS)%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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

1 Reply
Highlighted
Solution

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-...

 

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.