Re: >> Manual DTS

If you want to run the package on the client, you can retrieve the package using the package object LoadFromSQLServer method and then execute. You'll need reference the DTS package object library in the project and specify code like the example below in the button on-click event. See the SQL Server Books Online for DTS package object details.

Dim oDTSPackage As New DTS.Package2
oDTSPackage.LoadFromSQLServer _
"MyServer", , , 256, , , , "MyPackage"
oDTSPackage.Execute
Set oDTSPackage = Nothing

If you want to run the package on the server, one method is to create a job to run the package and then execute the job by executing the sp_start_job proc in the msdb database. The package will then asynchronously on the server.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Jonathan" <Jonathan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:15DE0168-4C88-41EA-8011-C1B1901D62AD@xxxxxxxxxxxxxxxx
Hi, what script will I use for the OnClick event of a button in an Access
front-end to run a DTS package (on demand)?

Many thanks
Jonathan

.