Best method is to have the SQL services running under their own account. This is independent of the login you use.

If the server doesn't need to access any network...

Don't be misled by things like table and field counts. The process of data scrubbing is done in many datawarehouses that hold 100's of gigabytes of data.

You need to isolate...

You can't, the meta data is not available because the table hasn't been created.

I would create a permanent table and use the under utilised lineage variables to sort out which user...

Firstly, please don't cross post.

Secondly, see the responses over here,

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=180268

Haven't done it myself, but you might be able to do it via some scripting. I've heard of methods that load VBScript for ActiveXScript tasks from a central package.

Probably a...

Check the Server Network Utility to see if you've got the TCP/IP or Named Pipes protocol enabled. By default MSDE installs with only Shared Memory protocol enabled which prevent any...

Maybe a bit more of an explanation would prevent us from guessing your intent.

Do you want to perform and transaction log backup for...

How is the data transferred now? ODBC, OLE/DB, Linked Server, etc ...

If you use the datapump task instead of the SQL task, then you can set a limit on the number of failing rows and log the error rows to a...

Actually there is more benefit to not using either of them. With the appropriate DBCC commands you can rebuild indexes and run consistency checks on individual tables. With sqlmaint you...

Excel can open tab seperated text files without any trouble.

I just posted this,

http://www.sqlserver.org.au/Resources/ViewResource.aspx?resourceId=40

Let me know if you have any problems.

Don't save the file as an actual template file (xlt). DTS won't know what to do with an xlt file. Keep it as an XLS file then use an short...

Do you mean page header/footer, or just headers for the data columns?

You could,

a) just create a tab delimited text file. Excel opens these fine. You get the column headers but...

There is no method of determing the name of the task itself. I have a similar setup for my error handling and had to manually put the task name in...