dbTalk Databases Forums  

Are DTS packages text editable?

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


Discuss Are DTS packages text editable? in the microsoft.public.sqlserver.dts forum.



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

Default Are DTS packages text editable? - 06-13-2006 , 10:31 AM






SQL Server 2000
XP Pro client
Existing DTS package called [POS SO], I want to add a task of delet all
rec's in a table

Are DTS packages text editable similar to T-SQL and SP's where you can
actually type in what you want instead of using the Ent Mgr GUI?

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Are DTS packages text editable? - 06-17-2006 , 09:41 AM






Hello Peter,

You could certainly create packages programmatically yes through something
like VB although that would be painful. Even the simplest of packages would
be an effort. DTS packages are not editable in the way you want through
anything like wordpad etc.


Allan


Quote:
SQL Server 2000
XP Pro client
Existing DTS package called [POS SO], I want to add a task of delet
all
rec's in a table
Are DTS packages text editable similar to T-SQL and SP's where you can
actually type in what you want instead of using the Ent Mgr GUI?




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.