• Yes, but it will recalculate that connectionstring every time it uses it (i.e. every time round the loop).

    Create a new variable User::FullOutputFileName (or whatever), and assign its value as:

    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]

    before entering the loop. (You'll probably need to do this in a script to ensure it gets the actual value rather than just the formula).