InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 21 Mar 2010 11:58:57 GMT20http://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxThanks Tim for the heads up. Yes - it was my wrong understanding of delimeter and text qualifier. As you suggested to doesn't matter if "" qualifier is not present for null column. Thank you.Fri, 20 Nov 2009 08:00:31 GMTsabyasmhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxTim,Sorry I missed your reply somehow. I will check this out and let you know.Thu, 19 Nov 2009 12:58:23 GMTsabyasmhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxFor the second issue (missing delimiters), I think you may be confusing delimiters with qualifiers. Delimiters separate values within your text, but qualifiers sort of do the opposite, keeping blocks of text together even if they contain the delimiting character - this is especially common in CSV files since you often find values such as "Smith,John" in a CSV file.That being said, if you have missing qualifiers for blank values, I don't think you'll have a problem with it (note: I haven't explicitly tested this - YMMV). If you have missing quotes around values such as Smith,John then you have a different issue which could get a little tricky.Shout back if this doesn't answer your question.hth,TimMon, 09 Nov 2009 22:26:16 GMTTim Mitchellhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxSorry, duplicate file upload... I did this once and it appeared to hang before the reply was done.Mon, 09 Nov 2009 22:17:55 GMTTim Mitchellhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxFor the original issue, unfortunately I don't have BIDS 2008 on this dev machine. I'll attach the C# code snippet, which will hopefully give you some insight into what I suggest (note that you'd need to translate it to VB.NET for use in 2005). I'll describe what is required:Ordinarily, you'll have one output row for each input row. However, since you're dealing with an unusually-formatted data file, that's not the case here. So you'll need to create one row in your output buffer (see the AddRow() method in the sample file), but you'll be building data from more than one line in the file (note the multiple calls to ReadLine()). This methodology does assume that you've got a consistent structure to the file, specifically that every sequential even/odd line number combination should be merged into a single row of data.Hopefully this makes some sense - the attached code file should help. Shout out again if you get stuck.hth,TimMon, 09 Nov 2009 22:10:48 GMTTim Mitchellhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxHi Tim/Others,Similar problem here. I am on VS2005 and unable to open the sample packages.My situation here is recordset with wrong delimeter: example "AAA","BBB","CCC","","DDD"[b],,[/b]"EEE......That is the 6th field comes as blank - whereas it is expected to be "".I wish to write a script task that would replace blank to "" and reformat the source flatfile before use it as a source.Checked the demo scripts from Tim's page - looks like they would have been of great help. But I am unable to open the VS2008 scripts :(Can you please get me a script code snippet to do the needful?Mon, 02 Nov 2009 10:46:31 GMTsabyasmhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxMine is 2005 version. Can you send 2005 version file please? If possible. or can you send screen shots or step by step procedure please?Thanks,bmrSat, 31 Oct 2009 19:17:48 GMTbmr270http://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxCould be a version incompatibility. What version of BIDS (Business Intelligence Developer Studio) are you using? The sample was developed using BIDS 2008.Fri, 30 Oct 2009 20:18:56 GMTTim Mitchellhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxThank you, BUT I am getting this following error and I am not able to open that packageTITLE: Microsoft Visual Studio------------------------------The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.------------------------------ADDITIONAL INFORMATION:The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.------------------------------BUTTONS:OK------------------------------Thanks,bmrFri, 30 Oct 2009 17:24:34 GMTbmr270http://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxYou'll most likely need to use a Script Component for this. I did a presentation on this a while back, feel free to download my sample code here: http://www.timmitchell.net/page/Resources.aspx, under the "SSIS Scripting" event for 8/1/2009.Let me know if you need a push in the right direction.hth,TimThu, 29 Oct 2009 19:18:12 GMTTim Mitchellhttp://www.sqlservercentral.com/Forums/Topic811321-148-1.aspxHi,I need to import unformatted text file to new table. Every row in text file continued in 2 nd row in the file. 2nd row started in 3rd row in the file. [b]FIXED LENGTH[/b] file.Example0001234567 John minneaplois 000-487-8374 minnesotaamerica xyz@abc.com 554640000998887 peter st paul 000-333-3333 jerseyamerica abc@xyz.com 088540000282822 kevin nashville 900-999-9999 tenneesseeamerica cde@feg.com 40404fist two lines are first rowsecond two lines are second rowthird two lines are third rowI need to create a new table and import the text file to new table. The text file is [b]FIXED LENGTH[/b]Thanks,bmrThu, 29 Oct 2009 18:56:41 GMTbmr270