Hi All, I want to load a CSV file which has 50 columns into a sql server table.My CSV file columns are delimited by Commas and rows are delimited by {CR}{LF}.The problem with the load is that I can load all the data except last two rows.The last two rows data looks like... RECORD_COUNT,TOTAL_TRAN_AMT 17115,0.000 How come SSIS can't load these last two records?

You are probably dealing with a trailer records that you do not need to load. SSIS cannot because they contradict to your import rule. See this forum post that offers several options: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/8454da9c-4ed1-4020-bcae-d00e60a8f1b9/Arthur My Blog

package returning any errors ?http://uk.linkedin.com/in/ramjaddu

Hi Arthur.. Thanks for your reply.I need to make use of the last record.I need to take last record value,17115 and need to compare with total number of records excluding these last two records.Do you have any idea as how to load these records also?even if I can take this last record value into a variable also fine .Do I need to use script component?

Hi Ram, No,its not returning any errors....but it skipping these last two rows and and loading everything...

Its contradict to SSIS imprt rules... you might need to find the way to split tailling rows onto different excel and import them separtely http://uk.linkedin.com/in/ramjaddu

You'll want to read Processing a Flat File with Header and Detail Rows. Talk to me now on

Thanks for your reply Todd.In my case rows are not identified with some labels. I think the below link might work best in this case http://geekswithblogs.net/evankoch/archive/2007/09/19/115450.aspx