title: BulkCopy with condition in C# for SQL Server
body: <p>I'm trying to copy data from one server to another. The database I'm copying from is very large and updated daily and I'm interested in just copying the previous day.</p>
  
  <p>Using <code>bcp</code> I can do this via the <code>queryout</code> option. Is it possible to set this when using <code>SqlBulkCopy</code>?</p>