• Sweet - thanks for sharing....

    One thing I found was for the step "Split FileList", the SQL statement being executed has a variable name in it. I had to remove it, due to an error, and replace it with a ?. It went from this:

    Select Item

    From stringsplitter(@FileExtensionList,',')

    to this:

    Select Item

    From stringsplitter(?,',')

    with the Parameter Mapping page looking the same as what you described. Just wanted to mentioned this in case anyone else ran into the error.

    I also tweaked it a bit to delete files based on hours, rather than days. We run into an issue with days sometimes, if a backup takes longer yesterday than it did today. The file we would be deleting would not be more than 24 hours old.