July 27, 2010 at 6:18 am
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 🙂
July 27, 2010 at 7:22 am
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.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply