![]() |
![]() |
We are currently migrating this forum over to our HelpSystems domain. Please post all new threads in our new HelpSystems Community Portal. |
![]() |
|
![]() |
AutoMate Discussion | ![]() |
help :
faq :
home
|
||
Latest News:
|
latest topics : statistics |
Topic Title: execution of a MS SQL Server DTS package Topic Summary: Created On: 03/30/2006 01:27 PM Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Here is a task that can be called from another task to execute a MS SQL Server DTS package. It takes 5 parameters...
1. BaseDirectory - a base path where the DTS log file will be written and to which the SQL Server specified in the "DBServer" parameter has access 2. DBServer - the database server where the DTS package is located 3. Username - a username that has permission to execute the DTS package 4. Password - the password of the aforementioned username 5. PackageName - the DTS package you would like to execute If a value is not supplied for any of these 5 parameters you will prompted to enter one. This feature also allows the task to be run on its own and prompt for values for all 5 variables. Now certainly, you could get a lot fancier with this by adding support for all the dtsrun command-line switch, but I just wanted to show the basics and you can add to it to meet your specific needs. Disclaimer: This will only work in SQL Server 2000 and earlier. I guess the dtsrun utility has been replaced by the dtexec utility. This link explains the changes. Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder) ------------------------- Thanks, Noel Scheaffer |
|
|
AutoMate Discussion
» GENERAL » Sample Tasks
»
execution of a MS SQL Server DTS package
|
![]() |
FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.