Post reply

How to save DTS packages to bas files

  • March 19, 2008 at 9:32 am

    #91656

    I am using SQL2000 and I am trying to save all of DTS packages as bas files auotmatically. I had read many messages here, but I haven't got any solution yet. Can anyone give me some examples on how to do it? Thanks a lot.

  • March 19, 2008 at 9:43 am

    #791519

    xtoolbar (3/19/2008)

    I am using SQL2000 and I am trying to save all of DTS packages as bas files auotmatically. I had read many messages here, but I haven't got any solution yet. Can anyone give me some examples on how to do it? Thanks a lot.

    Hello,

    You need to open the specific dts package and then click on Package --> Save As --> Location should be Structured Storage File

    Give the location where it should be saved as a file.

    Hope this helps.

    Thanks


    Lucky

  • March 19, 2008 at 10:21 am

    #791548

    Thanks for your reply. However, it is not what I wanted. I want to save it automatically by such as script or VB, VBA codes. Do you have any idea about it?

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

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