Your thought does make sense. But as far as I know, all email profiles can only attach a file written on hard disk.

Surely, you can assign data in buffer...

What service pack do you have? The following link may provide info on your error. May it help.

http://bugzilla.globus.org/bugzilla/show_bug.cgi?id=3403

Only SQL Developer version has max limit on concurrent users(5 or 10?). Check Microsoft website to confirm please.

You have two errors.

1. Data type conversion. You need to check your data and see whether or not they are convertible.

2. Try to avoid other users accessing your unc path.

Here is a link from Microsoft. May it help.

http://support.microsoft.com/kb/290991

Here is a link. May it help.

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic11857.aspx

The os error code indicates that the file is in use when you tried to have backup. See the link below.

http://www.search.stilegal.com/main/R10307.htm

In my memory, some of T-Scripts cannot be used in 4-name structure. Try other way to insert your data.

Did you check the setting of the update statistics for each database?

Does the following link help?

http://www.sqlservercentral.com/articles/Stored+Procedures/xpfileexist/183/

I would like to recommend to add the log file in your job to trace the detail error.

How about sp_who2 active?

Did you check whether or not the non-admin account has permission to do whatever in your DTS packages, such read/write on a folder?

May the link below help.

http://support.microsoft.com/?id=811889

In principle, you can. You just need to install your database on the nodes. But they will affect each other since they are on the same cluster.