InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 15:20:46 GMT20http://www.sqlservercentral.com/Forums/Topic1370655-148-1.aspxThanks for the replies, I tried both those ways (derived & transformation) prior to doing my idea and I was not able to get it to work. I was on the right track which is a positive probably just need to understand the process moreWed, 10 Oct 2012 03:02:16 GMTTavahttp://www.sqlservercentral.com/Forums/Topic1370655-148-1.aspxI'd do this by using a Conditional Split in the dataflow. Just redirect the unwanted rows to an output which goes nowhere, while letting the good rows run through as usual.Wed, 10 Oct 2012 00:51:42 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1370655-148-1.aspx1. You can make use of String Funtions in Derived Transformation to make change as NULL.2. Then use Row Count Transformation to get the count of empty or null.3. If the Row Count is greater than one, then don't load it.Please try. This may help you! :-)Wed, 10 Oct 2012 00:24:43 GMTsqlusershttp://www.sqlservercentral.com/Forums/Topic1370655-148-1.aspxHi all,I resolved the issue by doing a additional check in my stored proc, checking to see if a certain value <> ''The value should never be empty as it is a required field or it can't be inserted anyway.since the supplier file only has 3-5 rows a day there isn't any performance issue so the process is fine.However in saying that I am still interested if there is a way to perform this through the SSIS package -Tue, 09 Oct 2012 22:53:22 GMTTavahttp://www.sqlservercentral.com/Forums/Topic1370655-148-1.aspxHi All, Hopefully I can get a bit of help on the below.Firstly a bit of background I have a SSIS package which I've developed & runs perfectly fine,I simply pass a CSV through the Flat File Connection Manager which is automated from our FTP & as mentioned it works as expected however; some files we get from our supplier have a blank line in it which still gets inserted into the database obviously with incorrect information.The file is Comma Separated, and also with a text qualifer of " and format being "Delimited"Example of the file is setup like this.[u]Sample File 1:[/u] - BADDescription: Recieve 1 Supplier Code and 1 blank lineDate, Code, Name, value5/10/2012, TEL, Telstar, 52 , , , ,[u]Sample File 2:[/u] - BADDescription: Recieve No Supplier Code but just 1 blank lineDate, Code, Name, value, , , ,[u]Sample File 3:[/u] - GOODDescription: Recieve 1 Supplier Code this time no blank line.Date, Code, Name, value6/10/2012, PLS, Please, 11 How do i just ignore any lines if there blank , , , , ? i still want to import the good line.Tue, 09 Oct 2012 20:49:56 GMTTava