kingsfan76
asked on
Urgent: DTS package problem - Permission Denied
hi experts:
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!
kingsfan
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!
kingsfan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had the dll security set correctly.
I added sercurity access for the file "dtspkg.dll" (which is the MS DTSpackage object library referenced in the VB COM object). now the "permission denied" error is gone, but i get this new error:
>>> Automation error The specified module could not be found.
this error line is on
>> Set goPackage = goPackageOld
in COM object
the datatype for them are declared as the following:
>>Public goPackageOld As New DTS.Package
>>Public goPackage As DTS.Package2
I added sercurity access for the file "dtspkg.dll" (which is the MS DTSpackage object library referenced in the VB COM object). now the "permission denied" error is gone, but i get this new error:
>>> Automation error The specified module could not be found.
this error line is on
>> Set goPackage = goPackageOld
in COM object
the datatype for them are declared as the following:
>>Public goPackageOld As New DTS.Package
>>Public goPackage As DTS.Package2
ASKER
i couldn't get DTS with COM to work in our https server. Tried using ActiveX also, it works within the server but would not work from outside. Ended up using ADODB to read the xls and CSV files (had to do xls because Excel would not produce correct CSV files (No quotes on text string).
anyway i think permission is probably the problem... thanks for the response and i'll split the points with a grade of B, hope you guys don't mind
kingsfan
anyway i think permission is probably the problem... thanks for the response and i'll split the points with a grade of B, hope you guys don't mind
kingsfan
That sounds fine. Good luck with your project,
FtB
FtB
A "B".....ruined my night! :)
Good luck!
Good luck!
https://www.experts-exchange.com/questions/20301653/Running-DTS-packages-from-ASP.html?query=dts+permission+denied&topics=97]
http://support.microsoft.com/default.aspx?scid=kb;EN-US;252987