SQL Server Performance

ActiveX Task help

Discussion in 'SQL Server DTS-Related Questions' started by Jeffrey_D_York, Dec 9, 2004.

  1. Jeffrey_D_York New Member

    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!
  2. satya Moderator

  3. Raulie New Member

    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
  4. Jeffrey_D_York New Member

    Thanks! I Believe I have it worked out

Share This Page