Migration of SQL 2008 R2 Standard to SQL 2012 Standard - @flags parameter not valid SSIS

[Craig_DaviesB2]

Hi All,
I'm trying to perform a copy of a database to a new server using the SQL management object method so that the source can be kept online while we test if the copy was successful.
When copying we get the error this attached to this post.

I'm moving the database from an old Server 2003 box running SQL 2008R2 over to a new Server 2012 VM running SQL 2012.
I've tried copying from source to destination and also tried setting up the copy job on the destination server to pull the data across, however on both tries I get the same error
Error message screenshot at

http://files.engineering.com/getfil...8ad-44f5-ad0a-3d8c01ac9e66&file=sql_error.JPG

I'm not a sql engineer and have been tasked with simply moving the DB so any input from someone in the know is welcomed! I've done DB copies in the past without any hassle.

Thanks,
Craig

 

[simian336]

So have you attempted a backup and restore?

Simian