November 11, 2015 at 11:52 am
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
November 11, 2015 at 12:33 pm
Duplicate post. Here is the original. http://www.sqlservercentral.com/Forums/Topic1735535-148-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply