Tasks

Building a package using the wizards can solve your data transformation needs but what if you want to take it that one step further. In this section we show you how to make your DTS tasks more dynamic by responding to events around them or user prompted settings.

Global variable diagnostic script 8 Jul 2004	Intermediate 7.0/2000	53732 Hits
SQLDTS File Transfer Protocol Task 6 Jul 2004	Intermediate 7.0/2000	115955 Hits
Bulk Export Task 22 Apr 2004	Beginner 7.0/2000	120948 Hits
Global Variables and Stored Procedure Parameters 16 Feb 2004	Intermediate 2000	609863 Hits
Make the Execute Package Task name dependent only 5 Aug 2002	Intermediate 2000	24240 Hits
How to manipulate the Execute Process task. 14 May 2002	Intermediate 7.0/2000	47724 Hits
How to add a Dynamic Properties task to a package and manipulate it using VB. 14 May 2002	Advanced 2000	60449 Hits
Changing the DTS Send Mail Task 1 Jan 2002	Intermediate 7.0/2000	56638 Hits
How can I change the source data file for a Bulk Insert Task 23 Oct 2001	Beginner 7.0+/2000	29273 Hits
Global Variables and SQL statements in DTS 25 May 2001	Advanced 7.0+/2000	237803 Hits
Changing the DataPump Source and Destination Tables 18 May 2001	Intermediate 7.0/2000	40899 Hits