• Please will you explain what your whole package is doing? I don't think the OLE DB Command is the right component to use. It belongs in a data flow, and as far as I can tell, you're not doing any ETL here. If you're running a query to loop through a list of databases to restore, do that with an Execute SQL task, direct the result set to a variable, and loop through that with a For Each loop.

    John