SSISDB for SQL Server Integration Services
Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012. Brand new “SSISDB” database launched as SSIS catalog “A New repository database of Integration Services”. This new repository database brings a lot of abilities for developers, testers and administrators. Prior to SQL 2012 all SSIS packages are stored either in MSDB … Continue reading
DB Mail error “File attachment or query results size exceeds allowable value of 1000000 bytes”
Issue : One email report is working fine from long time but suddenly it failed today with below error. Error : Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes. Solution : Email report is failing at send mail because file attachment size is … Continue reading