That is all good but is it possible to do it without using CMDSHELL?

I used the script you provided:
RESTORE DATABASE DMPROD
FROM DISK = 'D:\VMDB2012$DM_DMPROD_FULL_20170830_020006.bak'
WITH CONTINUE_AFTER_ERROR, RECOVERY;

I  made some changes  and I was able to restore the database but...

I did that and received the exact same error.

I saw that error and did what you just explained. The backup is on the same machine so I created my sql command the following way.

EXEC sp_addumpdevice 'disk',...

I tried to run the restore in the following way:

RESTORE DATABASE DMPROD
    FROM DISK = 'D:\VMDB2012$DM_DMPROD_FULL_20170830_020006.bak'
    WITH MOVE 'CORDDB' TO...

Here is the error I receive.

Msg 9004, Level 16, State 3, Line 113
An error occurred while processing the log for database 'TEST'. If possible, restore from...

The restore does not complete, it produce an error and than stop.
The database remain in restore mode. Is there any way that I could remove the database from restore...

Thanks for your reply Andy, I hope to be able to read that article soon. The first article was pretty good by the way.

Good day Andy

I have just seen your article on scripting in SSIS part 1.

Could you tell me if part 2 is on it way to be publish as I cannot...

While reading the post, I noticed that this would also apply to me. Can you send me a copy of that project Plan? It would be greatly apreaciated. My Email...