i am executing SSIS package as Sql Job, inserting into DB2 table from SQL Server. When DB2 server become unavailable, SSIS job executing without any failure.
All settings and properties are default, is there any setting need to change to force SSIS package fail.
little confusing, how SQL job status say executing but target server become unavailable?
View Complete Post