<div>
Why not use bcp?<br />
Should be easier.
</div>


<div>
You can write an Active Script Task to change the name of the exported file to one that contains the date.<br />
<br />
The following works for me:<br />
<br />
Function Main()<br />
Const TempFile = &quot;d:\temp\test.csv&quot;<br />
Dim fs<br />
Dim fil<br />
<br />
Set fs = CreateObject(&quot;Scripting.Fi<wbr />leSystemOb<wbr />ject&quot;)<br />
Set fil = fs.GetFile(TempFile)<br />
fil.Name = fs.GetBaseName(TempFile) &amp;&nbsp;Date2MMDDYY &amp;&nbsp;&quot;.&quot; &amp;&nbsp;fs.GetExtensionName(TempFi<wbr />le)<br />
Set fil = Nothing<br />
Set fs = Nothing<br />
<br />
Main = DTSTaskExecResult_Success<br />
<br />
End Function<br />
<br />
Function Date2MMDDYY()<br />
<br />
Date2MMDDYY = Pad2Left(Month(Now())) &amp;&nbsp;Pad2Left(Day(Now())) &amp;&nbsp;CStr(Year(Now()))<br />
<br />
End Function<br />
<br />
Function Pad2Left(ByVal Value)<br />
<br />
Pad2Left = Right(&quot;0&quot; &amp;&nbsp;CStr(Value), 2)<br />
<br />
End Function<br />
<br />
Note: VBScript Format is somewhat limited, hence the extra functions. A file name normat of filename112001 would have been easier.
</div>


You can write an Active Script Task to change the name of the exported file to one that contains the date.

The following works for me:

Function Main()
Const TempFile = "d:\temp\test.csv"
Dim fs
Dim fil

Set fs = CreateObject("Scripting.FileSystemObject")
Set fil = fs.GetFile(TempFile)
fil.Name = fs.GetBaseName(TempFile) & Date2MMDDYY & "." & fs.GetExtensionName(TempFile)
Set fil = Nothing
Set fs = Nothing

Main = DTSTaskExecResult_Success

End Function

Function Date2MMDDYY()

Date2MMDDYY = Pad2Left(Month(Now())) & Pad2Left(Day(Now())) & CStr(Year(Now()))

End Function

Function Pad2Left(ByVal Value)

Pad2Left = Right("0" & CStr(Value), 2)

End Function

Note: VBScript Format is somewhat limited, hence the extra functions. A file name normat of filename112001 would have been easier.

<div>
<div class="content wysiwyg-content">
I am trying to export data from a table to a .csv file using DTS. The DTS package will be scheduled to run weekly and each file that is created needs to have the current days date included in the filename. For example, the files need to look like filename01012001.csv or similar.<br />
<br />
What do I need to add to the query to make this happen?<br />
<br />
Thanks in advance
</div>
</div>


I am trying to export data from a table to a .csv file using DTS. The DTS package will be scheduled to run weekly and each file that is created needs to have the current days date included in the filename. For example, the files need to look like filename01012001.csv or similar.

What do I need to add to the query to make this happen?

Thanks in advance

Add date to file name using DTS in SQL 7.0

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.