Viewing 2 posts - 1 through 2 (of 2 total)
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...
August 17, 2012 at 9:57 am
#1527156
There are two things you need to follow:
a. If you using a SQL server destination, switch it to OLEDB destination.
b. Use the Table/View load instead of Fast load.
This would help...
July 10, 2012 at 6:28 am
#1510862