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