hi all experts,
I created a SSIS package basically it's doing import process using excel connection. Now I'm trying to schedule this package.
the point is that this package should not failed during the scheduled time.
if someone forgot to close the excel file then package will be failed and give me an error at this time I want to send an email to
say "file is open, please close the file"
Or in the package property if i don't change 64bits as false the package will not running
and then give me an error then I want to send an email to say" please change the propertise".
Is there anyway to control both of these cases together?
Much appreciate If anyone can provide the detail script(c#) for this situation