ASP.NET and DTS: problems with CreateObject

From: Daniele (d.buonaiuto_at_gmail.com)
Date: 10/11/04 

Date: 11 Oct 2004 07:52:21 -0700

Hi all,
we are facing a serious issue about executing DTS packages from
ASP.NET.
In details:

1. use LoadFromSQLServer method to run DTS within ASP.NET
2. use of Win NT authentication
3. SQL Server is in mixed mode authentication
4. DTS runs regularly when executed from the Enterprise Manager
5. cannot use DtsRun for security issues
6. cannot use xp_cmdshell for security issues

DTS is run till ActiveX block script where it stops since cannot
instance objects using CreateObject function (ie
Scripting.FileSystemObject).
All the other operations are correctly executed.
Can you help?
Thanks a lot

Relevant Pages

  • Re: DTS Package not running
    ... Under the jobs it says executing and it can run for hours. ... When I run the job through DTSRUNUI it runs but when I schedule the ... The DTS does not period. ... >>> can run the jobs that does not have DTS package but if the job is DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: dtsrun.exe hangs before complete
    ... there fore it would need to be whereever the package is executing. ... www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun OnStart: Create table TABLE1 step ... > DTSRun OnFinish: Create table TABLE1 step ...
    (microsoft.public.sqlserver.dts)
  • Re: Unzip file using DTS
    ... Hello Jim, ... DTS with change of my directory name. ... And after executing DTS it says ... >> so that i can create activex task in DTS and test. ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to execute a DTS with scheduled job
    ... Also remember that DTS is a client application and as such runs on the box that says "go". ... This means you executing a package on ServerA from your Wkstn is very different from you executing a package on ServerA from the server itself. ... Why I read:Cannot open database '', ...
    (microsoft.public.sqlserver.dts)
  • DTS Authentication
    ... The user who will be executing the DTS has only SQL login. ... order to be able to copy the file to another server, like using Run as so I ...
    (microsoft.public.sqlserver.dts)