Permission problems ??
I am new to DTS Packages so hopefully there will a simple explanation for this. I am attempting to copy data from table1 on the
live server (srv1) to the same structure table on the test server. (srv2). I am building the DTS package on my local machine. I have two
connections set up (live and test) and a data transformation doing a select from table1 on live for certain rows. The destinatioan and transformations are set up correctly but whin I run the package I get the error
"The current user is not the database or object owner of
table 'RntTest4.dbo.cpty'. cannot perform SET operation ".
I have read access to the live server and insert /update access to the test server. Can anyone tell me what it is I am missing.
By the ay it is SQL SERVER 7.0 I am running on.
Thks in Advance ,