Post reply

Check for existence of specific words in a view through SSIS

  • June 8, 2011 at 2:40 pm

    #389691

    Hi all,

    Here is the situation

    I am using 2 Execute SQL tasks in a SSIS package.

    Delete records in onlineindex

    Insert records from a view that has been modified.

    Sometimes the modification in the view disappears(or someone forgets to carry them over from last month).

    I have been checking this manually, I would like to find a task that checks before the package is run(similar to if file exists set up).

    Can anyone tell me what to use to check for the existence of the modifications in the view itself. I have read alot on the If file exists, but I need to go one step further to see if a modification(line of code) exists in the view.

    Thanks

  • June 9, 2011 at 2:03 am

    #1336073

    You could extract the sql which makes the view and search that.

    SELECT OBJECT_DEFINITION(OBJECT_ID('vw_chkBreedDimension'))

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 9, 2011 at 5:28 am

    #1336184

    Thanks

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

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