ActiveX Task help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ActiveX Task help

Can someone point me in the right direction for an ActiveX Task. I am not very profecient in VBScipt. As a part of the DTS package I want to move a file to a location for archiving. I want to rename the file with a record from a SQL Table. I know the syntax for moving the file and renaming it, etc. I just need to know how to be able to query the table to get the data I need for the rename. Can I accomplish this through the Dynamic Properties task. I am examining it now, but still need a bit of help. Any help, as always, is appreciated. Thanks!
May refer to the for tips and tricks on ActiveX using explicitly with DTS. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
You can query the table in the activex script easily using ADO, put the value you want from the table into a variable/Global Variable then use the FileSystemObject model to rename the file. Raulie
Hewlett-Packard Company
Thanks! I Believe I have it worked out