Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2005-11-10 : 05:07:54
|
| Hi All,Recently, we just change our domain server. After the change, my DTS package fail to execute manually (via the DTS Designer). I'm using the domain user account to execute my DTS Package manually from the DTS Designer. However, I got the following error message:Step 'DTSStep_DTSActiveScriptTask_3' failedStep Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:Error Code: 0Error Source= Microsoft VBScript runtime errorError Description: Permission denied: 'CreateObject'Basically, this step is to create an Access file. The statement that failed is Set oCatalog = CreateObject("ADOX.Catalog").Can someone tell what is wrong with my DTS package? Is it something related to the security permission setting? Is it the problem with the domain user account that I'm using to execute the DTS package?Much appreciate if someone can help me to resolve this problem.Regards,William |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-11-10 : 17:38:35
|
| Does the user has write permission to the drive you're writing the access file to ?---Thanks!Igor. |
 |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2005-11-10 : 23:06:03
|
| Hi,Thank you for the reply.Yes, the user has write permission in the folder that I stored the access file. In fact, I try to put one ActiveX in my DTS Package to create a text in the folder and I manage to run the ActiveX successfully without any error. In other word, the user account that I use has the write permission in the folder. Is it something to do with the ADOX.Catalog object?? Regards,William |
|
|
|
|
|
|
Domain User Account & DTS Package Execution