MrAutomate
asked on
How do I send an attachment that changes daily in a SQL 2000 DTS send mail task
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.EXTRA CT.@100126 '
'TESTZZ2.ML.MLSETLLR.EXTRA CT.@100126 '
Tommorow the files will be :
'TESTZZ2.ML.MLMATLLR.EXTRA CT.@100127 '
'TESTZZ2.ML.MLSETLLR.EXTRA CT.@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!!
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.EXTRA
'TESTZZ2.ML.MLSETLLR.EXTRA
Tommorow the files will be :
'TESTZZ2.ML.MLMATLLR.EXTRA
'TESTZZ2.ML.MLSETLLR.EXTRA
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>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."
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."
ASKER
Thanks for the resource. I'll take a look , seems like a great website.
here:
http://support.microsoft.com/kb/312839