Post reply

Save all DTS Packages on a SQL 2000 Instance to VB Scripts

  • September 14, 2007 at 10:21 am

    #118270

    Now I know there are scripts out there that allow you to export all DTS packages to .DTS files but what I'm looking for is an automated way to perform the task of

    File -> Save As -> VB Script File

     

    Thanks!!!

    Colin
    http://benchmarkitconsulting.com

  • September 14, 2007 at 11:37 am

    #733850

    Ther have been many discussions on this. Check out this one

    http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=179518

  • September 14, 2007 at 12:10 pm

    #733860

    thanks for the link but if you read the thread in that discussion the suggestions that are made are either manually saving (which is what I'm trying to avoid) or scripts included are to save to a .DTS file (which can't be viewed/searched against)

    Unless I'm missing something I don't believe my question was answered in that thread

    Colin
    http://benchmarkitconsulting.com

  • September 14, 2007 at 1:08 pm

    #733871

    Sorry I may hav grabbed the wrong one. Just search for "Export DTS" in the site search option looking in discussion groups.

  • September 14, 2007 at 1:47 pm

    #733877

    hehehe everytime you reply you give me false hope

    I've searched the site and have found nothing.  I've found similar requests but no answers.  I can't believe that there isn't a genius out there that has done this.  (Hows that for sucking up?? hehehe)

     

    Thanks

    Colin
    http://benchmarkitconsulting.com

  • September 17, 2007 at 4:50 am

    #734033

    Hi,

      you can open up a DTS package in the Enterprise Manager and do a Save As and select a VB .BAS file.

    Also you can save DTS Packages created by the Wizard in VB. 

    I have noticed that sometime the lines are too long for VB and are broken, but its easy to go thru the code and see where this is happening as these lines will be in red and the code wont run!! I would also check to see if the line of vb has then been inserted with a line break  _  like the blue one there, to rectify the problem.

     

    I hope this helps,

    Ciao for now,

     

    Mike

     

  • September 17, 2007 at 7:49 am

    #734058

    Hi Mike

     

    Thanks for the reply but the goal is to automatically save ALL DTS packages as VB .BAS files.  In a situation where I have a couple hundred DTS packages opening each one individually and doing a FILE -> SAVE AS is what I'm trying to avoid.

     

    Colin

    Colin
    http://benchmarkitconsulting.com

  • September 17, 2007 at 9:28 am

    #734094

    A few days ago, I posted an identical question (phrased differently) at http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=398620

    Since then, I posted additional resources that might be of help to you.

Viewing 8 posts - 1 through 7 (of 7 total)

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