Open the dts package and save as ssl. This will save the package to a
file that you can copy and paste and reattach anywhere.

-----Original Message-----
From: Troy Du Plessis (T)
[mailto:mssqldba-ezmlmshield-x32711413.[Email address protected]
Sent: Tuesday, January 30, 2007 3:00 AM
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
To subscribe : 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
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page