Results 1 to 2 of 2

Thread: ActiveX Script Task] Error in SSIS

  1. #1
    Join Date
    Nov 2002

    ActiveX Script Task] Error in SSIS

    I'm trying to reset the below Global varialbe in SSIS - Activex script.

    Function Main()
    DTSGlobalVariables("GxvFilename").value =null
    Main = DTSTaskExecResult_Success
    End Function

    Getting the below Error when executing the package.

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

    Please provide me solution for this.


  2. #2
    Join Date
    Nov 2002
    No Worry,
    I found solution my self after with more test.
    The solution is the Activex Script not working as like SQL 2000. We nee to use " " instead of null for resting the global variables.
    MS need to give some reasonable error message for this kind of error.
    Good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts