rasika.segan (8/17/2012)
Can you confirm if the SQL server authentication login you are using belongs to the Admin group or has admin rights, if not try with admin rights and it should work.I too had the same issue and i did not change to OLEDB rather executed the package with admin account
Thanks.
I sure hope the original poster solved his issue 4 years ago 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP