Post reply

HELP !!!!!!!!!!! WITH -Double quotes 

  • June 28, 2012 at 8:50 am

    #258213

    Hey There ,

    In Derived column i am trying to create Double quotes  for 1 column . And i use code like this ("\""+ Day+"\"") but i am getting and error like this :

    ( My data type is DT_DBDATE)

    [

    Error at Data Flow Task [Derived Column [31]]: Attempt to parse the expression ""\""+Copy of Day+"\""" failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis.

    Error at Data Flow Task [Derived Column [31]]: Cannot parse the expression ""\""+Copy of Day+"\""". The expression was not valid, or there is an out-of-memory error.

    Error at Data Flow Task [Derived Column [31]]: The expression ""\""+Copy of Day+"\""" on "input column "Copy of Day" (273)" is not valid.

    Error at Data Flow Task [Derived Column [31]]: Failed to set property "Expression" on "input column "Copy of Day" (273)".

    (Microsoft Visual Studio)]

    Any idea guys ?

  • June 28, 2012 at 8:56 am

    #1506662

    Got It guys ,

    I just Convert Data Type to String [DT_STR]

  • June 28, 2012 at 8:56 am

    #1506664

    3935 (6/28/2012)

    Hey There ,

    In Derived column i am trying to create Double quotes? for 1 column . And i use code like this ("\""+ Day+"\"") but i am getting and error like this :

    ( My data type is DT_DBDATE)

    [

    Error at Data Flow Task [Derived Column [31]]: Attempt to parse the expression ""\""+Copy of Day+"\""" failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis.

    Error at Data Flow Task [Derived Column [31]]: Cannot parse the expression ""\""+Copy of Day+"\""". The expression was not valid, or there is an out-of-memory error.

    Error at Data Flow Task [Derived Column [31]]: The expression ""\""+Copy of Day+"\""" on "input column "Copy of Day" (273)" is not valid.

    Error at Data Flow Task [Derived Column [31]]: Failed to set property "Expression" on "input column "Copy of Day" (273)".

    (Microsoft Visual Studio)]

    Any idea guys ?

    Use the CHAR ASCII code instead i.e.

    CHAR(34) + "\" + Copy of Day + "\" + CHAR(34)

    ""\""+Copy of Day+"\"""

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

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

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