how to use DTS package?

[susie]

Can SQL DTS package be used in asp.net application? If it
can be used, can anyone show me how to use it? Say my
package name is "TranferFile"

 

[SSP]

Try creating a stored procedure and then call it in an asp.net page:

example:

CREATE proc spTranferFile as
exec master.dbo.xp_cmdshell "DTSRun /S SERVER NAME /U xxx /P yyy /N
TranferFile"
GO