Post reply

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

  • November 29, 2007 at 11:04 am

    #119584

    Hi

    I am using 2 connection managers in my ssis package pointing to same server.I used activex script to select server and assign it to connection managers.I declared 2 variables(package scope ).here is my code

    Function Main()

    DTSGlobalVariables("DBServer").Value = "devserver"

    DTSGlobalVariables("DBName").Value = "aa"

    ' DTSGlobalVariables("DBServer").Value = "proserver"

    ' DTSGlobalVariables("DBName").Value = "aa"

    With DTSGlobalVariables.Parent.Connections("connectionmanager1")

    .DataSource = DTSGlobalVariables("DBServer").Value

    .Catalog = DTSGlobalVariables("DBName").Value

    End With

    With DTSGlobalVariables.Parent.Connections("connectionmanager2")

    .DataSource = DTSGlobalVariables("DBServer").Value

    .Catalog = DTSGlobalVariables("DBName").Value

    End With

    Main = DTSTaskExecResult_Success

    End Function

    When I execute this task my connection managers should get connected to my devserver.but i got error?

    Can anybody help me woth this.

  • November 30, 2007 at 5:25 am

    #755899

    You really need to look at expressions and package configurations in books online. You should be very hard pressed to find any reason to use a script task to set properties on SSIS components at run-time.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply