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 🙂