Does the account you are using have appropriate permissions on Master on the target server? Bear in mind thaht datareader and datawriter are not sufficient to access system sp's...
Or alternatively, you could set up an SSIS package to export "TOP 10000000 FROM " set an exported flag on these records and loop until the count on the...