ASP.NET and DTS: problems with CreateObject -
10-11-2004
, 09:52 AM
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 |