February 1, 2012 at 7:15 am
Hello friends, I have a very simple export from SQL to a csv file.
I have a source, data transformation (for date and leading zero, etc) then I want to dump it into the csv:
example output:
Client Person Ref# LName FName Date Time Count Comment
XX4 A009 0807 FLOP TOM 1/30/ 0900 9999 Here are the comments, lots of commas,,,,blahhh
The last column 'Comment' is broken up in the source and individual rows contain one or many commas.
The obvious problem is that the output contains new columns when I want to isolate the comment text by row.
I am running SQL2005 and doing this in BIDS.
I have found some scrips that do the opposite of this but I am really stuck on this.
Any help would be greatly appreciated.
Many Thanks
February 1, 2012 at 12:58 pm
Hi again,
This objective is a work-around for a supplimental task for an application-driven db. That said I came up with a solution that is less-than elegant to be sure.
I added a Derived Column to the Data Flow and used the REPLACE function for " , " to " "
It removed the damn comma at least and my output file does not create a new column that I didn't want.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply