Go to the site below:

http://www.sqldts.com

there are various articles and samples that will help.

I have used an Activex script task to handle the dynamic filename using the script below

Function Main()

Dim oConn, sFilename

' Filename format

sFilename = "TEXTFILE"

If Day(Now())<10 Then sFilename = sFilename &...

Hi Larry,

I checked the url but I seem to have a problem with the package because it seems only one file(they are CSV files with the last few digits as...