Post reply

Restore a DTS package from a .bas file

  • November 20, 2003 at 2:59 pm

    #107411

    We've got some DTS packages that got stored as VB .bas files. Anyone know a way to recreate them on the server from this source?

    Thanks in advance...

    In the future we'll use structured storage files as that seems to be the easiest to restore

  • November 20, 2003 at 3:31 pm

    #482979

    In the .bas files, look for the line

    goPackage.Execute

    Just before this line is a commented out line to save the package to the server. Uncomment the save line and comment out the Execute line. You'll also need to edit the save line to have your Server name and login details.

    Then run the .bas file in VB.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • November 21, 2003 at 9:17 am

    #483146

    Thanks Phill - you da man!

    In that case, we may well stay with exported .bas files.

  • November 23, 2003 at 3:29 pm

    #483269

    It's probably best to keep to structured storage files. Unless you can be sure you will have VB available whenever you want to load the packages.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

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