Groups | Blog | Home
all groups > sql server dts > may 2006 >

sql server dts : Executing a DTSx package SSIS from a web page (ASP or ASPx)


jsql NO[at]SPAM comcast.net
5/3/2006 4:03:36 PM
I've researched this issue for half a day now and I can not find the
answer. We are launching numerous DTS pages from our current ASP web
page. We simply create a DTS.Package object, associate it correctly
and execute it. We are looking at updating to SQL 2005 and I'm trying
to find out the effects migrating our packages to SQL 2005 will have on
our environment. I've read all the articles that discuss how data
transformations are problematic and that it might take some leg work to
get things straightened out. That is all fine and good but it is
putting the horse before the cart.

Unforutnately I can not find a way to execute the migrated packages
(DTSx) from within our ASP pages. I've read about the command line
utility and I guess we could come up with a work around but it seems to
me that there has to be something fairly straight forward to accomplish
this task using jscript.
jsql NO[at]SPAM comcast.net
5/4/2006 8:05:09 PM
Anyone?
AddThis Social Bookmark Button