Sending mail within SSIS - Part 3: Execute SQL Task Case I want to send mail within SSIS, preferably HTML formatted. What are the options? Solutions There are a couple of solutions to mail within SSIS:…
RowCount for Execute SQL Task Case How do you get a rowcount when you execute an Insert, Update or Delete query with an Execute SQL Task? I want to log the number of effected rows…
Create a Row Id Case If you add records to a database table with an ID column, you preferably would use an identity column (Identity Specification, Is Identity = Yes…