How to Skip SSIS Column name case sensetivity

• Re1

  SSC Eights!

  Points: 991

  More actions

  October 28, 2015 at 6:56 am

  #309239

  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

• Phil Parkin

  SSC Guru

  Points: 246960

  More actions

  October 28, 2015 at 7:46 am

  #1836048

  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
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• Re1

  SSC Eights!

  Points: 991

  More actions

  October 29, 2015 at 1:10 am

  #1836252

  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.

• Phil Parkin

  SSC Guru

  Points: 246960

  More actions

  October 29, 2015 at 1:24 am

  #1836255

  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
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin