June 24, 2009 at 9:46 am
I understand sql server queries are not case senstive but recently when i was doing some trasformations using ssis pkgs i get error for case sensitive. As an example one of the compononent in my pkg loads data from source column (revdate) to Destination column (Revdate) but it fails with case sensitve error.
Why does SSIS treats revdate and Revdate as different , if ssis is case sensitive , is there a way to disable or ignore that and mo ahead with the process.
thanks
June 24, 2009 at 10:01 am
June 24, 2009 at 2:23 pm
I chcked that already but its not that option is only for look up componenet but i have problem with other regular componenets.
June 24, 2009 at 3:03 pm
conditional split is case sensitive too.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply