| Bill Swartz 2006-04-02, 3:27 am |
| Matthew,
What I would do is use the dynamic properties task to manage the file name
for the Destination file.
So the flow would be.
Use ActiveX to set the file name and update a global variable.
DTSGlobalVariables("ExportFilename").Value = myNewFileName
Execute the DynamicPropertiesTas
k to set the DestinationFile name based on
the global variable.
Execute the export
Bill
"Matthew Speed" <mspeed@mspeed.net> wrote in message
news:q2vn22t246mnht7
12m98bd4fh5lkho0dhq@
4ax.com...
>I have been asked to produce a set of csv output files for a number of
> subsets of data from a database. I have created a DTS package that
> can output each query to a hardcoded filename specified in the
> Destination file object in the package. As I have to do this
> appoximately 160 times I need to know how to change the name of the
> target file programmatically.
>
> I am guessing this will use an ActiveX script within the package to
> modify the target as the first action in the script. Can someone
> point me in the right direction to learn to be able to modify a
> property internal to the package by using an action in the package
> itself?
>
> TIA
|