Home Forums Article Discussions Article Discussions by Author Discuss content posted by Eduardo Pivaral SSIS Basics: Bulk-Import various text files into a table RE: SSIS Basics: Bulk-Import various text files into a table
epivaral
SSC-Addicted
Points: 428
More actions
October 9, 2018 at 10:59 am
#2008716
BrianWS1O - Tuesday, October 9, 2018 9:32 AMMine died at Execute Package. It said:Cannot bulk load because the file (xxx) could not be opened. Operating system error code 5(Access is denied.).But it imports the file just fine if I use the Import Wizard to create a DTSX file.
Cannot bulk load because the file (xxx) could not be opened. Operating system error code 5(Access is denied.).
But it imports the file just fine if I use the Import Wizard to create a DTSX file.
Hi Brian, this is a common issue using windows 7 or some restricted UAC OS, can you give it a try running SSDT as a Local Administrator?
MCSE, MCSA SQL Server Database Developer/Administrator