This might help.

Here's an interesting post

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/2be3325b-13ca-4672-b140-ddb0e815a4eb/

You are in luck. I'm currently still looking into this but have done a significant grind and configured the connection with ODBC....

Yeah Me

OK it worked. Not sure exactly what but here are two things that are important.

1) The Product Name. When You look into "MS SQL Server Mng Studio Express" under...

I think he's refering to this link::-)

==================

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/05258d18-d7e5-411d-b591-d98ba6674448/

To resolve this I believe all you need to do is add the users who will be accessing the linked server (remotely...