• cbrammer1219 (6/15/2014)


    I don't need all of the data, I am inserting the data from my original post to create a SSRS report, the data is coming from the flatfile which I am loading into SQL 2012 table. The other fields that aren't being inserted aren't needed for my report, this is something the 3rd party system is doing. Called Mettel...

    Just step a way from counting characters and spaces for a moment, could you tell us what you want to report on? If it is something like incoming call/outgoing call/transferred call, originating/terminating numbers, then you are indeed chasing ghosts and red herrings in flocks as the fields being ignored would hold all the information you are after.

    And there is more, a CDR will hold multiple records for a single call, A/B record for the call initiation, another for the pick-up/answer etc. Without knowing this logic and how to interpret the different record types this data is not going to make much sense.

    😎