RE: Scripting of DTS packages for MSSQL 2000

RE: Scripting of DTS packages for MSSQL 2000

 

  

Saving a package as a Visual Basic File is a one way street. There is no way to turn that VB script into a package again. Saving the package as a Structured Storage File allows the package to be reopened as a package, executed, edited, saved to a different server, etc.

You can save as a Structured Storage File from the Save As dialog in the DTS Designer. Or, you can do it from the command line DTSRUN with the /!X option.

So, there are a couple of options depending on what you are trying to do.

Jay

________________________________

From: Troy Du Plessis (T) [mailto:mssqldba-ezmlmshield-x32711413.[Email address protected]
Sent: Tue 30-Jan-07 05:00
To: LazyDBA Discussion
Subject: RE: Scripting of DTS packages for MSSQL 2000




Save the dts as a VB file .bas and open in vb.

tt

-----Original Message-----
From: De Wet Erasmus
[mailto:mssqldba-ezmlmshield-x72054667.[Email address protected]
Sent: 30 January 2007 11:46 AM
To: LazyDBA Discussion
Subject: Scripting of DTS packages for MSSQL 2000

Is there a way to script an existing DTS package in MSSQL 2000?

Any help will be appreciated.

Regards,

De Wet Erasmus



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page