dbTalk Databases Forums  

Executing a DTSx package SSIS from a web page (ASP or ASPx)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Executing a DTSx package SSIS from a web page (ASP or ASPx) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Executing a DTSx package SSIS from a web page (ASP or ASPx) - 05-03-2006 , 06:03 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.