Search Suggest

EXECUTE SQL TASK
EXECUTE SQL TASK

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…