SQL 2005 ActiveX Script Control - VB script lng

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

SQL 2005 ActiveX Script Control - VB script lng

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2007-07-30 : 05:31:17

Hi,

I get the following error when trying to add a VB script. I'm rewriting from SQL 2000 to 2005. but i get the following error when trying to parse

ActiveX Script Task
An error occurred while creating the ActiveX scripting host. Verify that the scripting host is installed properly.

I've checked on google but all I get is the error code. DTS_E_AXTASKUTIL_SCRIPTHOST_CREATE_FAILED

Please anyone help on a solution!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-30 : 05:56:38

Have you installed the 5.6 version (or later) scripting host on the server?

http://www.microsoft.com/downloads/details.aspx?familyid=C717D943-7E4B-4622-86EB-95A22B832CAA&displaylang=en
http://msdn2.microsoft.com/en-us/library/9bbdkx3k.aspx

E 12°55'05.25"
N 56°04'39.16"

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2007-07-30 : 09:57:03

Hi, Software is installed on the server.I'm not to sure if its my code.
Language - VB Script Language
Script - below script
My Entry Method - is blank, should it be blank?
Please help as I am stuck. No senior to assist as we just starting to change over (Nobody knows)
Thank You for your assistance!!!

(Simple delete file, this just a small part used to test the component)

Function Main()
sFile = "c:\dailySales.asc"
Set oFSO = CreateObject("Scripting.FileSystemObject")
If oFSO.FileExists(sFile) Then
oFSO.DeleteFile sFile, TRUE
End If
Main = DTSTaskExecResult_Success
End Function

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources