Hi,

I've got a connection object which executes a view to populate a csv
destination file. I have an activex script which is suppose to set the
filename and path of the csv file on completion of the workflow. The format
of the filename is ProcessLog_YYYYMMDD.csv.

The problem I'm seeing is that the csv file name isn't being changed every
time the package executes. So if the file gets created with the following
name ProcessLog_20030822.csv, then next time it runs it uses the same
filename rather than ProcessLog_20030823.csv.

Anyone got any ideas what is causing this problem??

Thanks in advance.

Glenn.

Have you got the datapump to "Close Connection on completion" in the
workflow.

Do you "Know" that it is resetting the filename ?

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

I've set the "Close Connection on completion" and still get the same
problem.

I wouldn't say it's reseting the file name but rather than generating a file
with a new one, it keeps using the same file name.

So it would generate a file with the following name
"ProcessLog_20030826_09_30_00.csv", then it keeps using this one rather than
generating a new one which has a time 5 minutes older. I know it's using
the same file as the time in the modified column in explorer changes
correctly.

Here's a copy of the activex script i'm using: -

Function Main()

mydate = now()

sFilename = "c:\ProcessReports\ProcessLog_" & Right(Year(mydate), 4)

If Month(mydate) < 10 Then sFilename = sFilename & "0" & _
Month(mydate) Else
sFilename = sFilename & Month(mydate)

If Day(mydate) < 10 Then sFilename = sFilename & "0" & _
Day(Mydate) Else sFilename =
sFilename & Day(mydate)

sFilename = DTSGlobalVariables("LogFilePath").Value & sFilename & "_" &
Replace(Time(), ":", "_") & ".csv"

Set oConn = DTSGlobalVariables.Parent.Connections("Destination File")

oConn.DataSource = sFilename

Set oConn = Nothing

Main = DTSTaskExecResult_Success

End Function


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Sorted now. Had to move the scripts position in the workflow as it was
executing after the file had been created.

Thanks and some of the examples on SQLDTS were helpful as well.

Glenn.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote