DTS Dynamic Properties question - Output to excel problem

[GJP55]

Is it possible to set somewhere in the dynamic properties box to create a worksheet on an output to excel if the worksheet doesn't already exist ?
I am using an ini file as the source.

Thanks

 

[jabrony76]

Not sure but you might want to create the file and then move and/or rename it using an activex script bringing in the global variable you caught in the dynamic properties task.

Andy

 

[GJP55]

Andy,

Thanks for your reply.
I have created the file initially in the DTS then set the Destination FileSource Name using Dynamic properties which works fine.

Thanks for your help.
Cheers,
GJP