After reading the error message it looks like "Microsoft OLE DB Provider for SQL Server" driver on your machine is missing. I think that is the reason because when you...

The easiest way according to me is to transfer them directly like:

-- All packages

insert into msdb.dbo.sysdtspackes

select *

from remote_server.msdb.dbo.sysdtspackages

where (blah.. blah)

                         OR                  

-- Latest versions of packages

insert into msdb.dbo.sysdtspackes

select...