use relative path for ssis packages dtsConfig files

to make the ssis package portable. A dynamic variable is important.

in the ssis, we use the dtsConfig file to store those dynamic variable.

however, the file path of the dtsConfig is absolute.

After seaching the internet. I get a method to make it become relative.

scenario 1: run from the command prompt

enter the following command at cmd:

dtexec /File Packagepath.dtsx /Conf configurationpath.dtsConfig

scenario 2: run from the SQL Server Agent

create a new job and insert a new step, select the type as "Operating system (CmdExec)"

enter the above command into the command box