I was Tryingtrying to use copy Database wizard from one server to another to make a certain database identical. and i got the error (The @flags parameter is not valid for a job step of type 'SSIS'. (Microsoft SQL Server, Error: 14545)).
(The @flags parameter is not valid for a job step of type 'SSIS'. (Microsoft SQL Server, Error: 14545)).
Some info might help:
-the Source Server is SQL 2008 R2 and the destination is SQL 2016.
-On Transfer Method i selected the second option (use the sql management object method) to keep the source Database online.
The Source Server is SQL Server 2008 R2 and the destination is SQL Server 2016.
On Transfer Method I selected the second option (use the sql management object method) to keep the source database online.
Any advice on how to solve this or where to check will be appreciated.