Post reply

importing data into flat file

  • October 23, 2006 at 6:44 am

    #91882

    Hi...

    How can I import data into a flat file "WITHOUT DILIMITER"

    For example it should look some thing like

    query2006-7-7out1976u

    where query -is some name,

    2006-7-7 is a second field,date and so on...

    I am using DTS for this but i am not able to get the flat file without dilimiter....

    Any ideas pls help.....

    Ur help will be helpful......

     

    Thanks in advance

  • October 23, 2006 at 8:40 pm

    #667489

    Can you post a bit more of your data?  I am guessing that things like "query" can vary in length.  Hence, you may have to loop through each line using CHARINDEX, (or some approach along those lines) and determine what will designate your starting and stopping points for each field. 

    I wasn't born stupid - I had to study.

  • October 24, 2006 at 2:50 pm

    #667698

    If you have a transfer data task in you DTS then in the options tab you can mention <none> as the value for row,column delimiters. You have to type it in.

    RH

  • October 25, 2006 at 10:41 pm

    #668085

    thank Q tat worked...

  • November 15, 2006 at 7:26 am

    #671945

    hi..when i give none in the column delimiter..It is printing none..in fact wat ever i give in the column delimiter between two columns....please help...

  • November 15, 2006 at 7:44 am

    #671956

    Hi Avanthi,

     

    Could you please provide some sample data

    Kindest Regards,

    Sureshkumar Ramakrishnan

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

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