Home
DTS FAQ
Administration
Connections
Execution
Tasks
Microsoft KB
Troubleshooting
Workflow
Tutorials
SQL 2005
Resources
Download
Links
Search
About
Copy Link
Newsletter
Add Favorite
Print
del.ico.us
Digg this
Professional SQL Server 2005 Integration Services
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
52852
Hits
SQLDTS File Transfer Protocol Task
6 Jul 2004
Intermediate
7.0/2000
114533
Hits
Bulk Export Task
22 Apr 2004
Beginner
7.0/2000
119604
Hits
Global Variables and Stored Procedure Parameters
16 Feb 2004
Intermediate
2000
605999
Hits
Make the Execute Package Task name dependent only
5 Aug 2002
Intermediate
2000
23968
Hits
How to manipulate the Execute Process task.
14 May 2002
Intermediate
7.0/2000
47378
Hits
How to add a Dynamic Properties task to a package and manipulate it using VB.
14 May 2002
Advanced
2000
60009
Hits
Changing the DTS Send Mail Task
1 Jan 2002
Intermediate
7.0/2000
56152
Hits
How can I change the source data file for a Bulk Insert Task
23 Oct 2001
Beginner
7.0+/2000
28979
Hits
Global Variables and SQL statements in DTS
25 May 2001
Advanced
7.0+/2000
236576
Hits
Changing the DataPump Source and Destination Tables
18 May 2001
Intermediate
7.0/2000
40496
Hits