http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8565.aspxFri, 17 Dec 2010 18:40:19 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8565Diana0http://sqlserver.ro/forums/thread/8565.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8565In import export wizard ---> choose a data source pune ca text qualifier " si mergi in sectiunea Columns. Va aparea un warning - "The flat file parser does not support......" - da OK, alege vertical bar ca si column delimiter, click pe refresh si continua wizard-ul. <br />Daca accepti ghilimelele in import lasa text qualifier none. Poti scapa de ele ulterior. <br />Incercat pe SQL 2005 SP3 si 2008 SP1 developer. <br />Altfel poti incerca bcp, SSIS package sau aplicatie custom.http://sqlserver.ro/forums/thread/8564.aspxFri, 17 Dec 2010 12:30:31 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8564Rdk0http://sqlserver.ro/forums/thread/8564.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8564Salut, <br /> <br />Incerc de ceva timp sa import un fisier flat file cu " incorporate in fiecare camp si avand drept delimitator pentru campuri |. <br />Ex: <br />"P014138630"|"BVD"|"058906114" <br /> <br />Atat cu wizardul cat si prin SSIS, nu reusesc sa elimin " si nici ca impart fisierul in campurile corespunzatoare. <br />Am descoperit ca este un bug de SQL Server: <br />http://connect.microsoft.com/SQLServer/feedback/details/312164/flat-file-parser-cannot-import-files-with-embedded-text-qualifiers <br /> <br />Ma puteti ajuta, va rog, cu un workaround?