I am trying to load a flat file with the Bulk Insert Task. However, I keep getting this error. I understand that it maybe a permission/security issue, so I made sure that I have Bulkadmin and sysadmin rights.
I even tried to place the file on my local drive (C), but I keep getting the same error:
[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\Deployment\AtmDialog20100713.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).".
Any ideas on how to fix this?
View Complete Post