Results 1 to 2 of 2

Thread: script to save dts packages as .bas

  1. 10-28-2005, 01:23 PM #1
    ravinder_k
    ravinder_k is offline Registered User
    Join Date
    Feb 2003
    Posts
    34

    script to save dts packages as .bas

    Looking for a script to save all dts packages as visiual basic file (.bas). The script MAK suggested uses a filestorage and uses .dts files...
    Reply With Quote Reply With Quote
  2. 10-31-2005, 07:29 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    DTS has methods called loadfromsqlserver and savetofile (I think). You can write VBscript to get packages collection and go through load and save routine.

    Try searching for script in www.sqldts.com, they have plenty of scripts.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules