How to Skip SSIS Column name case sensetivity

  • Hi,

    In my SSIS package , I have changed one of table column name from upper case to lower case for Ex."EMPLOYEEID" to "employeeid".

    After changing case i am facing an error as "Error: "component "OLE DB Destination" (16)" failed validation and returned validation status "VS_NEEDSNEWMETADATA"."

    I am aware that SSIS is case Sensitive.Total 500+ data flow task are there in my SSIS package which i can't change manually as going into data flow task and update the metadata mapping.

    I am looking for solution to resolve this problem or else any work around for to skip the case sensitivity in metadata.

    Thanks,

    Revan

  • revanappa.shivanagi (10/28/2015)


    Hi,

    In my SSIS package , I have changed one of table column name from upper case to lower case for Ex."EMPLOYEEID" to "employeeid".

    After changing case i am facing an error as "Error: "component "OLE DB Destination" (16)" failed validation and returned validation status "VS_NEEDSNEWMETADATA"."

    I am aware that SSIS is case Sensitive.Total 500+ data flow task are there in my SSIS package which i can't change manually as going into data flow task and update the metadata mapping.

    I am looking for solution to resolve this problem or else any work around for to skip the case sensitivity in metadata.

    Thanks,

    Revan

    You have a package containing more than 500 dataflows?

    Take a copy of your package, then open the copy in a decent text editor.

    Do a case-sensitive find/replace for the modified column name, then open the package & see whether it works.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Thanks Phil,

    I cant do find/replace 500 times.That why I am Searching for is there any way to Skip the case sensitivity in SSIS.

  • revanappa.shivanagi (10/29/2015)


    Thanks Phil,

    I cant do find/replace 500 times.That why I am Searching for is there any way to Skip the case sensitivity in SSIS.

    No.

    Now I suggest you change your sentence to: "I don't know how to do find/replace 500 times in an efficient and fast way".

    As you have only 1 package, you need do it only once.

    If you typed your thread wrongly and actually have multiple packages, you need to find a tool which will go through all of them and do the find/replace for you.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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