DTSRun Action

Connection & Security

SQL Server

Server

The name of the server that the SQL server exists on. This can be its IP address or its name.

Server instance

The name of the specific database instance to connect to on the supplied server.

Security

Use integrated security

Uses a trust connection where a username and password are not required. The current user does require domain access to the specified SQL server and instance.

Username

The username to use connect to the SQL server with.

Password

The password that matches the supplied username to connect to the SQL server.

DTS options

Repository database

DTS package

Package name

The name of the DTS package. This would have been assigned when the package was created.

Package GUID string

The ID of the DTS package. The ID is a GUID.

Package version GUID string

The DTS package version. This would have been assigned when it was either first saved or run. Note that a new version ID is assigned each time it is modified. The version ID is a GUID.

DTS package from file

The name of the DTS package file to load. The package is retrieved from the SQL server being connected to and loaded into the structure storage engine.

Options

Package password

The password for a password protected DTS package.

Name of package log file

Specifies the name to use for the DTS packages log file.

Specify package global variables

A list of variables to define for the DTS package. Note that if the user credentials supplied don't have ownership writes over the DTS package the packages default variables will be used instead. Using and supplying a package password is another way to get these variables applied.

Delete DTS package from SQL server

Specify this option to delete the DTS package from the SQL server the action is connected to.