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 |
|
Krb_iiaba
Starting Member
16 Posts |
 Posted - 2005-07-28 : 14:07:55
|
| We have a DTS package that is scheduled to run on a nightly basis. This package has suddenly stopped working and is returning the following error:ActiveX Scripting Transform 'DTSTransformation__1' was not able to initialize the script execution engineI have scanned the Microsoft Knoweledgebase and have found nothing describing the same error.Any suggestions are greatly appreciated. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-28 : 17:18:08
|
Can you run VBScript elsewhere on that server? Try creating a text file containing something likeMsgBox "Scripting works!!" and save it as test.vbs and try running it. Tim |
 |
|
|
Krb_iiaba
Starting Member
16 Posts |
Posted - 2005-07-28 : 17:36:29
|
| Good question, one of the things I didn't think to check. And to answer your question, yes it does work. I actually tried re-registering the axscphst.dll (DTS ActiveX script host) and I still get the same error message. |
|
|
|
|
|
|
DTS/ActiveX Error