i've build connection path variables -

ImportSourcePath = C:\OnKeyImports\WorkOrderCosting\Source\

FilePrefix = WorkOrderCosting

FileExtension = .txt

and build it in the connection string like this to add date in the file name:

RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2) + RIGHT("0" + (DT_WSTR,2)DatePart("dd", GetDate()), 2) +

"_" + RIGHT("0" + (DT_WSTR,2)DatePart("hh", GetDate()), 2) + RIGHT("0" + (DT_WSTR,2)DatePart("mi", GetDate()), 2) +

RIGHT("0" + (DT_WSTR,2)DatePart("ss", GetDate()), 2) + @[User::FileExtension]