Home Forums SQL Server 2005 SQL Server 2005 Integration Services load multiple xml file into a single flat file destination RE: load multiple xml file into a single flat file destination

  • April 19, 2013 at 6:03 am

    #1608165

    Andrew Watson-478275 (4/19/2013)

    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).

    Another way of doing this is to have a static name for the output file and then to rename it after the data flows have all completed.