goto control panel/administrative tools /services

select MSSQLSERVER service

select logon tab

change logon account to windows account

FYI - local system account will not be able to access resources outside the server.

I think you should change the logon account to a windows account. This way you will be able to access the network.

Ok when you run a job the process runs under the context of the  SQL service logon account. So you need to check if that account has the relevant permissions.

I think the first thing you should do is run the Index tuning wizard to help identify any major bottle necks.

If you want comprehensive  audit of your table design there...

The DTS wizard is more than capbable of implementing the functionaling that is specified in the URL link.

You can use the DTS import and Export wizard. Very quite straightfoward