Re: Restore a DTS Packaga Saved As Visual Basic File?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 18:57:42 +0100

Open the VB module file in VB and add a reference to the DTS Package Object
Library. Scroll to the bottom of Sub Main and you will find two options,
either go_Package.Execute or go_Package.SaveToSQLServer. You want to call
the SaveToSQLServer method, so ensure that is setup correctly with server
name and credentials, and the Execute call is commented out.

Run the project. 

-- 
Darren Green
http://www.sqldts.com
"Anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:D7F9E5B5-FEA6-478B-B39F-33BA0480AE31@microsoft.com...
> SQL Server 2000 DTS package deleted from MSDB.  No MSDB backkup.  DTS
package previously saved as a Visual Basic file (vaulted in SourceSafe).  Is
there a way to restore the DTS package to the SQL Server MSDB using only the
Visual Basic file?

Relevant Pages

  • Re: Where in msdb can I find Active X Scripts from a DTS package
    ... DTS Package data is stored in a system table in msdb, called sysdtspackages, ... How to Upgrade to SQL Server 2000 Retail Version After SQL Server 2000 ... I am trying to recover a DTS package containing an ACtive X Script after my ...
    (microsoft.public.sqlserver.programming)
  • Re: Permission for running DTS
    ... Add them to msdb. ... You could also go through the DTS stored procs and grant access to them ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > still run the DTS package in any other way without adding ...
    (microsoft.public.sqlserver.dts)
  • Re: recovery of dts packages
    ... Was your colleague saving the dts package to SQL Server? ... data can be found in the sysdtspackages table of msdb database. ...
    (microsoft.public.sqlserver.dts)
  • Restore a DTS Packaga Saved As Visual Basic File?
    ... SQL Server 2000 DTS package deleted from MSDB. ... DTS package previously saved as a Visual Basic file. ... Is there a way to restore the DTS package to the SQL Server MSDB using only the Visual Basic file? ...
    (microsoft.public.sqlserver.dts)
  • Re: Searching for a column name in many DTS packages
    ... there is an option to save the DTS package as a ... Visual Basic file. ... If you could save all your packages to a folder as VB ... files, then you could do a file level search on those files, in Windows ...
    (microsoft.public.sqlserver.dts)