Post reply

Export DTS syntax

  • July 12, 2005 at 12:24 am

    #66728

    Hi there,

    Would somebody happen to know of a way to export all the syntax (sqls, vbscripts etc.) from any given DTS package to an output file?

    This would greatly assist in streamlining documentation.

    Regards,

    David

  • July 12, 2005 at 12:44 am

    #573236

    DTS packages are stored as binary objects in the msdb database, as such you can't export all the details.

    To get the whole package in a readable form, you could save the package as a VB file.

     

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

  • July 12, 2005 at 12:50 am

    #573238

    Perfect!

     

    Thanks for the prompt reply.

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

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