Hi friend,

You can´t to use the SQL Server Destination on remote server...

Instead, the packages should use the OLE DB destination

http://msdn2.microsoft.com/en-us/library/ms141095.aspx

Regards!

Lucas