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 thehttp://www.sqldts.com for tips and tricks on ActiveX using explicitly with DTS. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
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

]]>