DTS a large file

I currently have a DTS that runs a Stored procedure.

The stored procedure does a hit from a few table and returns a large amount of data (100K + rows).

I tried to set up the DTS to send me the file as a .csv, but it is simply to big of a file.

Is there a way I can get this to work, do I have to use winzip or something of that nature?

I simply want the sql hit to run each month and the DTS to run the command to email me the file.

Any idea would be appreciated.What other alternatives do you have to emailing ? What will you do with the file once it has been emailed to you ?|||The file is used in a statistical program by the marketing department.

Thanks
Tom|||Instead of emailing, why don't you just ftp ?|||Originally posted by rnealejr
Instead of emailing, why don't you just ftp ?

We were hoping to have the DTS run every month and send me the file.

The idea was to make this an automated as possible.

That is why I hoping I could just have the DTS email me the .csv.

I am not sure what you mean by FTP, I know what FTP is, but are you saying that I should FTP the file after it has been created?

Thanks
Tom|||One of the tasks available with dts is a "file transfer protocol task". How are you creating the csv using dts ?