Executing a SQL DTS package from an ASP page

[david7777777777]

Does anyone know how to execute a DTS package on a SQL 2000 database from an ASP page? Thanks.

 

[cbokowski]

Put the call to the dts package in a stored procedure and then execute the stored procedure from asp.

hth

 

[david7777777777]

How do you write a stored procedure, with regular SQL code?

 

[cbokowski]

Yes.

its covered well with sql server books on line.

here is a link for it.

SQL BOL:

http://www.davidpenton.com/sqlbol

 

[david7777777777]

From what I'm seeing in BOL and using Enterprise Manager, it seems that you can only use a stored procedure to insert, delete, or update rows???

 

[cbokowski]

dtsrun is a utility to launch dts packages. see link below

we build the command line string in our sp. and then
execute xp_cmdshell with the string to get the process going.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp

 

[david7777777777]

Thanks. What does the "xp" stand for in xp_cmdshell?

 

[cbokowski]

extended procedure. there are others that ship with sql server. we use xp_sendmail to let us know when our dts packages have completed.

 

[david7777777777]

The more I learn, the more I realize there is to learn. wow.