Bulk Insert / Load not allowed with SQL auth sysadmin account..

I have tried everything...not sure what to do
Michael KatzAsked:
Who is Participating?
 
DcpKingConnect With a Mentor Commented:
Can you show the error message you get, and the ccode you're using? Also, if you're sure it's correct, ask your friendly DBA to try to log in and run the code for you i he or she usually has "God" access, so you'll find out pretty quickly if it's your code or your access rights!

hth

Mike
0
 
TempDBACommented:
Need more information. Does sql auth sysadmin account has proper permission on the text \csv files you are using for bulk inserts?
0
 
DcpKingCommented:
So I assume that it was your access rights that were the problem ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.