Are there any saved / protected login credentials in the package? The protectionLevel might be set to EncryptSensitiveWithUserKey, which is why it works for you and not the SQL Agent...

http://msdn.microsoft.com/en-us/library/ms151761%28v=sql.90%29.aspx

On a multi-core cpu, CPU time can be more than elapsed time. Try the query again with MAXDOP = 1 and CPU time will be less or equal to...

Can you make it work with SQL authentication first? If so, then you'll know if it's an SPN / authentication issue.

eg

EXEC master.dbo.sp_addlinkedserver @server = N'linkedservername', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'linkedservername',@useself=N'False',@locallogin=NULL,@rmtuser=N'remoteSQLlogin',@rmtpassword='remoteSQLpasswrd'

GO

http://www.pythian.com/blog/moving-master-database-to-new-location-in-sql-cluster/

Make sure the new drive is a clustered resource too.

There's plenty of walkthroughs on the net, best practises here: http://blogs.msdn.com/b/pamitt/archive/2010/11/06/sql-server-clustering-best-practices.aspx

Good FAQ: http://www.brentozar.com/archive/2012/02/introduction-sql-server-clusters/

Walkthrough: http://dbperf.wordpress.com/2010/07/10/walkthrough-cluster-setup-sql-win-2008/

Make sure you consider licencing costs and ensure your clients apps will reconnect after a fail-over.

If the old publication does not have any subscribtions, you can drop it using:

EXEC sp_droppublication @publication = 'oldpublication'

But make sure there's no subscriptions first.

Add the missing view (or all views)...

Does the view "vwTrip_Leg" exist on the subscriber?

Function is ok (although if it runs on a server in a different timezone/regional setting it wont be correct, if it was named get_time_minus_1_hour it wouldn't matter).

How are you using...

According to this url http://ms-abhay.blogspot.com.au/2010/08/could-not-load-dll-xpstar90dll-or-one.html, you need to reinstall the SQL Native Client. It is unusual for it to become corrupt, but since there are a few cases of...

Have you thought about using database mirroring or log shipping?

I dont fully understand the requirements or problem from what you've said.

If there's multiple copies of spreadsheets floating about, why not use Sharepoint to store them which includes...

-- Good basic information about memory amounts and state

SELECT total_physical_memory_kb, available_physical_memory_kb,

total_page_file_kb, available_page_file_kb,

system_memory_state_desc

FROM sys.dm_os_sys_memory WITH...

I might not totally understand the requirements here, but couldnt you just use a TSQL task to import the dataset where it only grabs data where SENT = 0.

eg. ...

http://www.sqlskills.com/blogs/kimberly/indexes-just-because-you-can-doesnt-mean-you-should/