Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS package SQL Tasks - Renaming processed files RE: SSIS package SQL Tasks - Renaming processed files

  • March 30, 2010 at 9:17 am

    #1142336

    david.morrison-1035652 (3/30/2010)

    Phil Parkin (3/30/2010)

    There is another option which does not require script. Put the whole process inside a FOREACH container. When the package executes, if the FOREACH container does not find a matching file, the package completes gracefully.

    If the specified source file is found, processing continues as required.

    Phil, are you eStalking me!? 😉

    :alien: be afraid. SSIS predators are not to be taken lightly.

    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.