• That's what my concern was too. The problem in your solution is that Archive Folder is in a parameter already. I put the parms and values in a table variable, then loop through that to assign the values and call the Catalog.set_execution_parameter_Value proc. I have logic that if it is an integer, then it passes an integer value instead, but otherwise they are already nvarchar values.

    For better, quicker answers, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/