<div>
how about a call to a sp<br />
<br />
here:<br />
<a href="http://support.microsoft.com/kb/312839" rel="ugc">http://support.microsoft.com/kb/312839</a><br />

</div>


how about a call to a sp

here:
http://support.microsoft.com/kb/312839 [http://support.microsoft.com/kb/312839]


<div>
&gt;&gt;how about a call to a sp&lt;&lt;<br />
The user is using DTS or perhaps you did not see the comment:<br />
&quot;I do not have admin rights to my SQL server, so no XP_commands, etc.&quot;<br />
<br />
<br />

</div>


>>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."




<div>
Thanks for the resource. &nbsp;I'll take a look , seems like a great website.
</div>


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

<div>
<div class="content wysiwyg-content">
Experts. &nbsp;I do not have admin rights to my SQL server, so no XP_commands, etc.<br />
<br />
I need help, step by step, on how to send the following attachment in my DTS package. &nbsp;<br />
<br />
The file attachment change daily as follows for 2 daily files:<br />
'TESTZZ2.ML.MLMATLLR.EXTRA<wbr />CT.@100126<wbr />'<br />
'TESTZZ2.ML.MLSETLLR.EXTRA<wbr />CT.@100126<wbr />'<br />
<br />
Tommorow the files will be :<br />
'TESTZZ2.ML.MLMATLLR.EXTRA<wbr />CT.@100127<wbr />'<br />
'TESTZZ2.ML.MLSETLLR.EXTRA<wbr />CT.@100127<wbr />'<br />
<br />
and so on changing each day. &nbsp;<br />
<br />
I am not sure if this is an active x task or a dynamic peroperties task , and need help.<br />
Note the ' is an actual character in the file name...not my Idea and not my files &nbsp;:)<br />
We will say the source path will be c:\temp<br />
<br />
Thanks!!<br />
<br />

</div>
</div>


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!!



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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.