dbTalk Databases Forums  

Install and uninstall DTS package using a script

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Install and uninstall DTS package using a script in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
McGeeky
 
Posts: n/a

Default Install and uninstall DTS package using a script - 10-06-2005 , 06:01 AM






Can the installation and uninstallation/deletion of a DTS package be
scripted? I want to include it as part of an automatic installation wizard.

Thanks

--
McGeeky
http://mcgeeky.blogspot.com




Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Install and uninstall DTS package using a script - 10-06-2005 , 06:54 AM






Yes.

You can copy a file as part of installation.
You can use the object model to call teh Load and Save methods for teh
relevent storage locations.
You can insert a package directly into sysdtspackages, saving your GUIDs
from changing as they woudl with the SaveAs.

It depends on where you define the installation location, file system or
Local Package store - MSDB (sysdtspackages)

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"McGeeky" <anon (AT) anon (DOT) com> wrote

Quote:
Can the installation and uninstallation/deletion of a DTS package be
scripted? I want to include it as part of an automatic installation
wizard.

Thanks

--
McGeeky
http://mcgeeky.blogspot.com






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.