dbTalk Databases Forums  

ASP.NET and DTS: problems with CreateObject

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


Discuss ASP.NET and DTS: problems with CreateObject in the microsoft.public.sqlserver.dts forum.



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

Default 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

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.