DTS Package & Excel

[Lynn]

I am using SQL Server 2000 and Access 2000. Does anyone
have the code to run a DTS package via a command button on
an Access form.

Also, if the package runs successfully I would like it to
open up an Excel file.

 

[J. Clay]

I created a stored procedure to run my dts package and used the following
command:

EXEC master..xp_cmdshell 'DTSRun /S SQLServer /N "Update Web Data" /E',
NO_OUTPUT

You can lookup DTSRun & xp_cmdshell in SQL Books On Line for more info.
After the SP is complete you can then open an Excel file. One option for
this would be to use the Application.FollowHyperlink (?) command in access.
Look that up in help to get the specific usage.

HTH,
J. Clay