July 27, 2010 at 11:13 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 27, 2010 at 11:34 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic959826-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply