I am working on a project where I will be loading 50-100 tables from an Oracle source to SQL. I want to write the Destination tablename, starttime and endtime to a table so users can see what the status of the loads are. I added event handler that does this but I am not finding a way to dynamically insert the table name of the destination. My first thought was to just to name the package the same as the destination table but I'm not finding a system variable that will work. Any suggestions?
This works but the table name is static:
"INSERT INTO Table_load_log(TableName,StartDate,EndDate) VALUES ('Table1','" + (DT_WSTR, 10)(DT_DBDATE)@[System::ContainerStartTime] + " "+ (DT_WSTR, 8) (DT_DBTIME)@[System::ContainerStartTime]+ "',GETDATE())"