InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:57:54 GMT20http://www.sqlservercentral.com/Forums/Topic459606-148-1.aspx[quote][b]karthi (2/25/2008)[/b][hr]Hi,I have a flat file without delimiters. The format is like L10123444 221but Col1 = L;col2=1;col3=0123444 etc...how to import this kind of flat fileThanks in advance[/quote]All of the methods suggested, so far, are good and will do.If you want absolute blinding speed, though, using Bulk Insert with a BCP format file will out perform just about anything else you can do. The information for a BCP format file is in Books Online.Mon, 25 Feb 2008 10:19:05 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic459606-148-1.aspxIn the SSIS Data Flow you would use a Flat File Source. Configure the sources connection manager to use the "Ragged right" format and mark where the columns should be delimited, including the appropriate row delimiter. In the Advanced options change the properties for each column, such as Column name, data type and width. Then connect that to your destination.If the fields won't be in the same position and same width the above won't work. For that you could still use a Flat File Source and read each row to a single column, then split that row up within a Script Component. Mon, 25 Feb 2008 07:10:40 GMTTodd Engenhttp://www.sqlservercentral.com/Forums/Topic459606-148-1.aspxUse fixed length option in flat file connection managerMon, 25 Feb 2008 06:57:35 GMTDinesh Asankahttp://www.sqlservercentral.com/Forums/Topic459606-148-1.aspxHi,I have a flat file without delimiters. The format is like L10123444 221but Col1 = L;col2=1;col3=0123444 etc...how to import this kind of flat fileThanks in advanceMon, 25 Feb 2008 04:17:25 GMTkarthi-646351