Post reply

Generate script for DTS package

  • December 9, 2003 at 1:27 pm

    #160424

    Does anybody know how to generate the script for DTS structure(package)?

    I have DTS packages that consultant created, some of them did not work any more, I want to generate the script for the package structure, so I can know what he was trying to do.

  • December 9, 2003 at 1:51 pm

    #485422

    if the package owner has password protection and you don't know it, AFAIK you are out of luck

    but if no owner password was assingned all you have to do is open it from EM in the Designer. This is NOT going to give you a script but you will be able to see what was done internally


    * Noel

  • December 10, 2003 at 4:19 am

    #485491

    there are 2 reason:

    1- make sure that allcomponent which you used while creating this DTS still exist on the computer now.

    2- authorization to open this DTS

    overall you cant create any script untill you open it and from file select save as then select location/structured storage file

    can you tell me what is the message you see when you try to open this DTS

  • December 10, 2003 at 7:10 am

    #485528

    Open the DTS package in EM; right click and choose "Save As...". For the Location, choose Visual Basic File.

    Hope this helps!

    Bryan

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

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