Post reply

Change File Path in a DTS.

  • December 8, 2004 at 10:49 am

    #165598

    I have several DTS Storage files that are run from activex script from a DTS that is run from the server. In each of the DTS Storage Files is a file that is import/exported. It is referenced by a path. For instance, \\path\path1\file.

    I have about 30 of these DTS files. Is there a way to replace that path with a new one from script or do I have to open each one and change it. Hopefully, I have explained my problem clearly.

     

    Thanks

    Tom

  • December 9, 2004 at 5:02 am

    #533161

    I do not believe that the layout/format of the structured storage file is documented.  I have looked for information on this topic to provide the ability to export task scripts to text files. But was unsuccessful in finding any finding any documented information on the format.

    There are a few options ways you could make your life easier in the event you ever have to change this path again in the future.

    First, replace all instances of the path and file name with a DTSGlobalVariable.  You can set the variable at the package level, or modify your variable to be read from a file, table via query, or use the dynamic properties to set the variable when the package is executed.

    -Mike

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply