Post reply

Header Delimiter with Flatfile connection in SSIS

  • January 21, 2015 at 10:32 am

    #150854

    Hi,

    I have a flat file which needs to be imported to SQL Database. My flat file contains Quotes as header delimiter. How do i remove that from header while imported?

    Ex: "Employeename","City","State"

    I know i can use the derived column transformation with replace functions but there are like 100 column headers. Is there a simple way to do this?

  • January 21, 2015 at 11:15 am

    #1771943

    susmitha117 (1/21/2015)

    Hi,

    I have a flat file which needs to be imported to SQL Database. My flat file contains Quotes as header delimiter. How do i remove that from header while imported?

    Ex: "Employeename","City","State"

    I know i can use the derived column transformation with replace functions but there are like 100 column headers. Is there a simple way to do this?

    I think you mean text qualifier rather than delimiter. Have you tried specifying " as the text qualifier?

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

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