How to fragment data in csv file?

  • Hi ,

    I am importing data from csv file to sql server tabls. Now the csv file is not comma or space delimited. Instead when i creat e the flat file connection ,the data in csv comes in a single column . Now i want the data to be fragmanted like position 1-5 in column 1 , position 6-12 in col2 and likewise . How can i achieve this using flat file source .?

    Also i want a specific data to be inserted like position 1-7 should go in col1 of destination table A and position 8-12 in col2 of table A and likewise..

    I want the answers for both the methods .

    Can anybody Help..

    Regards

    Aditi 🙂

  • Define your flat file source to be fixed width (not CSV). Then define your fields based on start pos / length etc - haven't done it for ages, so can't remember the details, but hopefully this will get you on the right path.


Viewing 2 posts - 1 through 2 (of 2 total)

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