Post reply

Problem with the script task and conditional split

  • November 13, 2008 at 5:33 pm

    #126880

    Hello All,

    I'm looking for help on following two issues.

    1. Script Task

    I'm seeing a wierd thing happening with the script task. I'm using it to check if a file exists or not in the given filepath. It executes fine sometimes and fails sometimes with the error "The script files fail to load". Could anyone please let me know the problem and soultion for it.

    *I set the script task Delay Validation to True

    2. Conditional Split

    I'm publishing an error file based on some criteria used in the conditional split. The invalid records will be redirected to error file and valid records will be loaded into a table. However, an empty error log is created even if there are no invalid records. Could anyone tell me what should I use if I want the error file to be created only when there is some invalid data.

    Your help is greatly appreciated.

    Thanks,

    -Amith Vemuganti

  • November 13, 2008 at 9:15 pm

    #898397

    I would recommend when you have multiple issues to create multiple posts for each.

    My recommendation for the 2nd issue is to run a script task after it finishes executing the data flow task, which checks for the length of the error log. If the length is zero, just delete the file.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • November 14, 2008 at 8:24 am

    #898643

    Thank you!

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

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