how to call a dtsx with asp?

Question

Post reply

how to call a dtsx with asp?

fred2002

SSCrazy

Points: 2943
More actions
October 8, 2008 at 7:21 am

#213846

Hello,
did somebody know how to call a dtsx with asp?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

POCTOB Right there with Babe Points: 790 More actions · Answer 1

POCTOB

Right there with Babe

Points: 790

October 8, 2008 at 7:58 am

#882279

xp_cmdshell -google it

Steve Jones - SSC Editor SSC Guru Points: 738337 More actions · Answer 2

From ASP you have two choices. The first is call DTSRUN with the dtsx file as a parameter, but if it takes any amount of time, you'll have a timeout on the ASP side.

The other way is to schedule the dtsx as a job (no times) and call sp_startjob from ASP. It will come back and then you can query the server with a refresh to see when it completes and get status.

POCTOB Right there with Babe Points: 790 More actions · Answer 3

You can also create stored proc and exec xp_cmdshell inside it

how to call a dtsx with asp?

Cookies on SQLServerCentral