Detailed logging for Transfer SQL Server Objects Task

  • JoNTSQLSrv

    Ten Centuries

    Points: 1360

    Hi all,

    I need to use 'Transfer SQL Server Objects Task' to  transfer sql server object(specific tables) from one sql server to another but i need to do custom logging to a table about the list of  table tranfered , row count & time it took to load each table.

    can i use event handler (pre execute , post execute ) and execute sql task in it ? or is there any other easy and effective way to do this ?

    Version : visual studio 2015

     

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply