Home Forums SQL Server 2005 Business Intelligence What is the best way to make SSIS execute package task connections portable ? RE: What is the best way to make SSIS execute package task connections portable ?

  • hi,

    When i try this @[User::Exec_Path]+"\\"+ @[System::TaskName]+".dtsx"

    i get below error message

    ------------------------------

    The variable "System::TaskName" was not found in the Variables collection. The variable might not exist in the correct scope.

    Attempt to parse the expression "@[User::gv_DtsxFiles_Root]+"\\"+ @[System::TaskName]+".dtsx"" failed and returned error code 0xC00470A6. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

    (Microsoft.DataTransformationServices.Controls)

    --------------------------------

    thanks,

    suresh