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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.