Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SSIS changing the case of a string in derived column output

Answered SSIS changing the case of a string in derived column output

  • Thursday, July 26, 2012 8:18 PM
     
     
    Sign In to Vote
    0

    I have a SSIS package which imports data from SQlserver to SQLserver ,am using SSIS 2008.

    In have a derived column transformation in middle of the dataflow which is as

    (indicator) == "Y" ? "Yes": "No"

    The output is coming as YES and NO for some of the rows. and for some of the rows its appearing correctly as "Yes" and "No". The case of the strings is getting changed.

    Can anyone help me to fix this problem

     

All Replies

  • Thursday, July 26, 2012 9:06 PM
     
     Proposed Answer Has Code
    Sign In to Vote
    0

    Hey ,

    Did you try the UPPER Function on the output

    [COLNAME] == "Y" ? UPPER("YES") : UPPER("NO")


    Regards, Dinesh

    • Proposed As Answer by Dinesh Menon Thursday, July 26, 2012 9:07 PM
    •  
     
  • Friday, July 27, 2012 8:00 AM
     
     
    Sign In to Vote
    0
    Do you have any other components after the derived column? The case will not change by itself.

    ~V http://btsbee.wordpress.com/

     
  • Friday, July 27, 2012 8:05 AM
     
     Answered
    Sign In to Vote
    1

    This is the hardcoded value i.e. "Yes" or "No" it should not change.check the input indicator for those rows where case is changing.

    Regards

    Samay

    samay

    • Marked As Answer by SSISNewbie345 Friday, July 27, 2012 2:31 PM
    •  
     
  • Friday, July 27, 2012 8:06 AM
     
     
    Sign In to Vote
    0

    This is the hard coded value i.e. "Yes" or "No" it should not change.check the input indicator for those rows where case is changing.

    Regards

    Samay

    samay

     
  • Friday, July 27, 2012 8:07 AM
    Moderator
     
     
    Sign In to Vote
    0

    Add a Data Viewer directly behind the derived column and let us know what you see. If that show correct values then some other component is changing the case. In that case describe your package.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Friday, July 27, 2012 8:08 AM
    Moderator
     
     
    Sign In to Vote
    0

    Add a Data Viewer directly behind the derived column and let us know what you see. If that show correct values then some other component is changing the case. In that case describe your package.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Friday, July 27, 2012 2:33 PM
     
     
    Sign In to Vote
    0
    I have fixed the issue by truncating and reloading the table ....because actually load to a staging table and then update it to the main target and intially i have run the pkg  with derived col having caps YES and NO. so the problem is fixed....Thanks all for your inputs

    k.sravani