 <p>First, I'd better do it on SQL Server side :)<br> But if you don't want or cannot to do it on server side you can use this approach:</p> <p>It is obvious that you need to store SessionID somewhere you can create a txt file for that or better some settings table in SQL Server or there can be other approaches.</p> <p>To add columns <code>SessionID</code> and <code>TimeCreated</code> to OLE Destination you can use <a href="http://www.dotnetfunda.com/articles/article1233-use-of-derived-column-in-ssis.aspx" rel="nofollow">Derived columns</a></p>