How do I send an attachment that changes daily in  a SQL 2000 DTS send mail task

MrAutomate
MrAutomate used Ask the Experts™
on
Experts.  I do not have admin rights to my SQL server, so no XP_commands, etc.

I need help, step by step, on how to send the following attachment in my DTS package.  

The file attachment change daily as follows for 2 daily files:
'TESTZZ2.ML.MLMATLLR.EXTRACT.@100126'
'TESTZZ2.ML.MLSETLLR.EXTRACT.@100126'

Tommorow the files will be :
'TESTZZ2.ML.MLMATLLR.EXTRACT.@100127'
'TESTZZ2.ML.MLSETLLR.EXTRACT.@100127'

and so on changing each day.  

I am not sure if this is an active x task or a dynamic peroperties task , and need help.
Note the ' is an actual character in the file name...not my Idea and not my files  :)
We will say the source path will be c:\temp

Thanks!!

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Commented:
These articles can explain it a lot better than I can:
How can I change the filename for a text file connection?
http://www.sqldts.com/200.aspx

Working with files and the FileSystemObject
http://www.sqldts.com/292.aspx

Changing the DTS Send Mail Task
http://www.sqldts.com/235.aspx
x-menIT super hero

Commented:
how about a call to a sp

here:
http://support.microsoft.com/kb/312839
Top Expert 2012

Commented:
>>how about a call to a sp<<
The user is using DTS or perhaps you did not see the comment:
"I do not have admin rights to my SQL server, so no XP_commands, etc."


Author

Commented:
Thanks for the resource.  I'll take a look , seems like a great website.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial