January 21, 2015 at 10:32 am
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
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?
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply