SSIS error handling

  • addition info: there are multiple folders I have to go through to check each folder if excel file is opened or not .should I have to create one foreach loop and one variable to check these?

  • caojunhe24 (4/17/2015)


    addition info: there are multiple folders I have to go through to check each folder if excel file is opened or not .should I have to create one foreach loop and one variable to check these?

    It depends but then again, I'm not certain I fully understand the question, can you explain what you are trying to do and where you are having problems?

    😎

  • Now I have a task deal with SSIS package which is must handle (if excel file is open by another user then stop the package and send an email & if there is no "DataMatrix"tab in excel then send an email.) I'm trying to use script task using c# language to implement this logic since send email task is blocked by firewall.

    can u provide the script code?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply