Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 03/30/2006 01:27 PM
User is offline View Users Profile Print this message

Author Icon
Noel
AutoMate Coach(200+)

Posts: 237
Joined: 04/01/2005

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
Statistics
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 866 guests browsing this forum, which makes a total of 866 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog