dbTalk Databases Forums  

SQL Code for writing DTS packages..

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


Discuss SQL Code for writing DTS packages.. in the microsoft.public.sqlserver.dts forum.



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

Default SQL Code for writing DTS packages.. - 12-02-2003 , 07:11 AM






Do these have to be designed in the DTS Designer, or can they be written somewhat differently to the GUI in Enterprise Manager?



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

Default Re: SQL Code for writing DTS packages.. - 12-02-2003 , 08:48 AM






You can write DTS packages in VB if you really want. You can see how this
is done by saving your existing packages as a VB .bas file. The GUI gives
you a simple and intuitive way of creating packages and hides the
complexity.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Traci" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Do these have to be designed in the DTS Designer, or can they be written
somewhat differently to the GUI in Enterprise Manager?





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

Default Re: SQL Code for writing DTS packages.. - 12-02-2003 , 08:57 AM



You can write DTS packages in VB if you really want. You can see how this
is done by saving your existing packages as a VB .bas file. The GUI gives
you a simple and intuitive way of creating packages and hides the
complexity.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Traci" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Do these have to be designed in the DTS Designer, or can they be written
somewhat differently to the GUI in Enterprise Manager?







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.