Post reply

DTS package to be copied in a text file

  • January 18, 2007 at 1:14 pm

    #171857

    My AD team needs to have a few DTS packages copied to a text file (vb script) so that they can compare those packages as they have made some errors.  Can someone please let me know how to get those packages in a text file?

    Thank you.

     

  • January 18, 2007 at 1:31 pm

    #684099

    It seems to me that there is no way converting a DTS package to a text file. A too fast conclusion? I wish someone have a soultion. But you may try to recreate the package in a text (vbScript) when using import/export data.

  • January 18, 2007 at 2:10 pm

    #684106

    Go into the DTS designer and select Package>>Save As...  When the 'Save DTS Package' window appears, click on the 'Location' drop down list and select 'Visual Basic File'.  This will save the file out to a .vbs flat file that you can then use to compare to another .vbs DTS package file.  I assume this is what you want when you say a 'text file (vb script)'. Correct?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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