Hi!

I am using DTS to import data on daily basis and I have 10 packages
that handle 10 different file formats.
Connection task in File Name contains the full path for the input
file.
Is there any way to use relative path or System variables with a file
name to be more flexible in deployment?

For example:
%MyProgData%\Orders.dat
instead of D:\XXX\XXX\XXX\orderds.data