Within SQL Server 2000, if you wanted to execute a command line task (e.g. execute a BCP statement within DTS such as "bcp <arguments>"), a common task would be to use a ActiveX Script Task to create your command line statement. This command line statement would then be placed within a global variable. Then a dynamic variable task would be used to take the global variable value and place it within the Arguments property of the Execute Process Task. For SQL Server 2005, you can use SQL Server Integration Services (SSIS) to do this task much simpler. You can…