Hi! I need help here...
I want to schedule a daily overwrite copy from one database with a new name on the same server.
Using the Copy Wizard I was able to set everything up but it fails with Error 12550 when running.
Source and Target are the same machine
I am using SMO Method
The SQLSERVERAGENT user has rights for local execution and local activation for SSIS
Any help appreciated.
Guenter