I am new to SSIS, I have a 39 tables in source and same tables in destination, The source and destination both are in SQL Server 2008 databases. So i have taken one sequence container in side container i have set to 39 data flow tasks. In data flow tasks i have put OLE DB Source and OLE DB destination, Based on created data daily i have moved records from source to destination.
Now on this package i am ready to deploy the job so once package run successfully or failure case and how many records inserted and updated in destination tables, those information i need it on a mail. The information should be in table format like given below.
Table Name Compare Column Source DB Count Destination DB Count Updation Status
abcd CreatedDt -- -- No data difference
abcd_info CreatedDt -- -- No data difference
com_info UpdatedDt -- -- Moved sucessfully
daily_stats CreatedDt 1936 1936 Moved sucessfully
abc_data CreatedDt 3872 3872 Moved sucessfully
abcd_history CreatedDt -- -- Error
Thanks & Regards,