Post reply

combining two columns into one

  • November 22, 2006 at 12:03 pm

    #173514

    I'm doing an import of do not call list numbers for someone in my marketing department. it's a text file with a comma separating the area code and the number that he downloads from the website. he wants it all in one column.

    I'm trying to make it look nice. In my flat file source i have it divided up into two columnns so i don't have to use a string and use integer data types instead. Now I have to combine it into one column.

    is there a transform to do it or should I just use two import paths of one column each and then use a merge transform?

    I want to keep it as an integer because he has cold call list that he needs to scrub against the do not call list and i wanted to make it part of the SSIS package.

  • November 22, 2006 at 12:04 pm

    #673558

    Why not keep them separated in the DB and merge them in his application and reports?

  • November 22, 2006 at 12:05 pm

    #673559

    Err sorry : in YOUR application .

  • November 22, 2006 at 12:11 pm

    #673560

    he is just using MS Access and I was going to link a table to the SQL database. He has Access 97 and said he couldn't import the data. The way the files are, i don't think he will be able to get the data the way he wants it via Access.

    I thought i would automate the whole process for him so all he has to do is look at his to call list that's already been scrubbed.

  • November 22, 2006 at 12:37 pm

    #673565

    How about import in 2 columns. Clean his cold call list then return is list?  Maybe there would be a need to concat but I guess you know about the + operator by now !

  • November 22, 2006 at 6:25 pm

    #673624

    going to play around with this on the weekend

    i tried the derived column transform and concated the two columns into a third. Package ran, but i only got the phone number and not the area code + the number

    the original files are pretty bad and it looks like the easiest way is to use delimited and put the data into two columns. area code and the 7 digit number. i'm also going to look into a transform using substring and just taking the first three characters, delete the comma and the next 7 characters and drop the box looking thing at the end.

Viewing 6 posts - 1 through 5 (of 5 total)

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