July 27, 2010 at 11:10 pm
Hi ,
I am importing a csv file wihich is not delimited by anything ..means when i define the flat file connection manager i see the all the data coming in single column . the file contains some abrupt data also like ** , space,hyphen,. I want to fragment thos data based on some condition like from position 1 upto length 7 it should go in 1 col. then from pos 8 to 12 in another col and like wise .There should be in all 10 dotAfter fragmanting this data i need to insert this in Sql server tables stating conditions that if data contains " . " then dont insert or insert only rows when not empty .
Can this be done using temp tables ?
I am finding very difficult to work this out .
Can anybody help me ...
Regards
Aditi
July 28, 2010 at 1:03 am
Hi..
Use script task to solve this,write .net code for this .
Regards..
guru12
July 28, 2010 at 1:38 am
If there is no delimiter, it is, by definition, not a CSV file.
It's a fixed-width file and you can use SSIS to import it and break it into its constituent fields by defining it as such.
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
July 28, 2010 at 6:22 am
Hi ,
Thanks Phil .
U are right. Its a fixed width file and i used ragged right format to exactly define the width of the column .
The problem is solved.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply