Active X Script Error - SQL Server Forums

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 2005 Forums

SSIS and Import/Export (2005)

Active X Script Error

Author

Topic

suketu9
Starting Member

13 Posts

Posted - 2007-10-31 : 17:04:56

We are converted our DTS 2000 packages to Sql Server 2005 SSIS. I am getting following error on my ActiveX script that got converted. I am new to SSIS and DTS. Never ever worked with ActiveX also. So any help would be appreciated. Following is the script followed by error I get:

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()
DTSGlobalVariables.Parent.Steps("Record Stats").DisableStep = False 'Record Stats

if (DTSGlobalVariables("FILE_EXISTS").Value > 0) then
'right click on task, go to workflow, options to see task name
DTSGlobalVariables.Parent.Steps("SET VALID FILENAMES").ExecutionStatus = DTSStepExecStat_Waiting ''call SET_VALID_FILENAMES
DTSGlobalVariables.Parent.Steps("Record Stats").DisableStep = True 'do not run l
end if

Main = DTSTaskExecResult_Success
End Function

Error I get Is:

[ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x000A39BC.

Thank You

suketu9
Starting Member

13 Posts

Posted - 2007-11-01 : 10:19:18

Anyone knows how to fix this error.

ekb18c
Starting Member

18 Posts

Posted - 2007-11-18 : 21:49:13

I don't think the script is the problem. I would check your global variables and see if they are set correctly. The error you are getting is stating the file is not there!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources