Urgent: DTS package problem - Permission Denied
Posted on 2004-08-25
I created a DTS package in SQL Server 2000 to import simple CSV file. It works in sql server. Then I saved the DTS package as VB file and edit it by adding a form and a button to execute it in VB. It works perfectly in VB. Then finally I copy and paste the codes into a new ActiveX DLL project to generate a COM object so I can use it in my ASP pages.
Now here's the problem:
when I run the ASP page to execute the DTS COM, I get the "Permission Denied" error.
I know the DLL register correctly because the 1st debug statement in the COM object shows. It is the main function where it execute the DTS package gets the "permission denied" message. So what did i missed? how can i fix the problem? any help will be greatly appreciated!