Re: Web interface calling DTS package with parameters

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 22:42:09 +0100

Do you mean like this

Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207) 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
<imani_technology_spam@yahoo.com> wrote in message
news:8be6e8.0406041319.7fff4aed@posting.google.com...
> Is there a way for a Web interface to execute a DTS package and pass a
> parameter to the package?

Relevant Pages

  • Re: DTS Error EXCEPTION_ACCESS_VIOLATION
    ... >>We have some DTS jobs that runs every night called via a ... >>Package ... If this is no help, then please describe how you execute the package, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: ETL rejects records intermittently
    ... The data source is the SQL SERVER 2005 table. ... We first dump the data from ... When I execute the SSIS package ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >execute rather than just assigning its sql statement and execute it later.I need the result in my Activex Script. ... > 'EXIT from function if there is another instance of the same package is running ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS and MSDE
    ... that does the calling of the package as the package runs from the place calling ... I will presume that the package is stored on a SQL Server somewhere. ... The above error is not appearing the in the vb app (removed error ... I've even used the "sa" login to execute the dts pkg and still ...
    (microsoft.public.sqlserver.dts)
  • Re: Export to Text File Fails from Server Box
    ... If you are on WKSTN1 and you pick up a package from SVR1 and press execute, ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... >I should have specified in my question that in re-creating the text> connection, I did point in to a file local to the SQL Server. ... When I click on the>>> Destination tab, there is an execute button. ...
    (microsoft.public.sqlserver.dts)