Cheap - Use Access or Excel.

If you have a web server already, write some asp and it won't cost you a penny.

What code are you using in the stored procedure?

It is possible to do.

Open up the mailbox. Select [Export to a file]

Select something like [Microsoft excel].

Select the folder you want to export

Give the filename and location. You can map...

Investigate the data driven query task.

For the files see:

http://www.sqldts.com/default.aspx?292

To send a mail use either the sendmail task in dts or xp_sendmail. Check BOL as there are plenty of examples of xp_sendmail

This question and similar ones are asked time and time again.

The answer unfortunately remains the same. Not easily.

In order to do this, you would have to delve into the object...

Consider writing an activex task that creates a text file using filsystemobject and then writes the values of the variables to the text file. That way you can tell exactly...

From what I know, the only real differences are:

1.Functions return a single value whereas stored procedures can return multiple.

2.Non-deterministic functions are not allowed in functions but are for stored procedures.

What the hell type of query are they running?

Generating a temp db six times the size of the database is not normal practice and must take forever to run. I...

The simplest way is to have another step that renames the file after each run. Something like a batch file.

To do it within DTS:

Create a global variable

Create a Dynamic Properties...

This guy is telling you the truth.

Excerpt from microsoft site:

'N-to-N Column Mappings

Transformations using N-to-N column mappings require a matching number of multiple source and destination columns. You use this mapping...

The only comparison should be between stage and destination.

Stage should really be used for collecting all available data before decisions are made in regards to populating targets.

IE - source -...

I agree with you. However, there are a lot of Organisation's out there who will still be using 2000 2 or more years from now.

At least that is the impression...

If you cannot guarantee a last updated stamp is correct, then the best policy is to presume none of the data in the two tables exists.

Therefore, you will need to...

The logical way would be to use the filesystemobject. However, there appear to be no attributes that allow you to find out if a file is open.

The policy you should...