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 ?

  • Name the Package Task the same as the child package you are trying to run and use:

    @[User::Exec_Path]+"\\"+ @[System::TaskName]+".dtsx"

    Example: child package is "BlahBlah.dtsx"

    Name the package task in your master package that kicks it off as

    "BlahBlah". Call the task name instead of the package name in the expression (as above).

    Viola