Post reply

how to skip one problematic file and move next file

  • October 15, 2008 at 11:52 pm

    #124285

    Hi All,

    In the Folder i have files.These files are loading into the database.But the problem is that whenever one file is having any problem.The process will not stop.It needs to send the file to error folder and do the next file loading.How to achieve this?Any suggestions highly appreciable

    Thanks,

  • October 16, 2008 at 1:48 am

    #885670

    Hi,

    Which method are you following to load files to DB. If you are using DTS, you may try "On Completion" workflow instead of "On Success".

    [font="Verdana"]Renuka__[/font]

  • October 16, 2008 at 2:03 am

    #885674

    Hi,

    Thanks for the response.I am using SSIS.I don't know how to set completion workflow

  • October 16, 2008 at 2:51 am

    #885689

    Hi,

    Leading from one task to another, there are arrows (workflow). Blue indicates "On Completion"; Green indicate "On Success" and Red indicates "On Failure". If we doubleclick to open the workflow, there is an option to choose as per the requirement.

    [font="Verdana"]Renuka__[/font]

  • October 16, 2008 at 3:01 am

    #885692

    Thanks Renuka.I will do that.

Viewing 5 posts - 1 through 4 (of 4 total)

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