Hi I need to remove the last record from a text file? What's the easiest approach to do this using SQL Server Integration Services? Thanks.

You don't say what the last record looks like. Is it different then the rest of the records or does it have some indicator that means it is the last record, other? Without knowing how to detect the last record it is hard to say how to remove it. Some possible options: 1. If it is different then the rest of the records you possibly can configure the error output to get this record if it is enough different that the parsing fails. 2. If you can detect the row in some manner you could use conditional split to filter it out. 3. For other you would have to say how it can be detected. Matt

A couple of generic options for doing this: Use a script to preprocess the file and remove the last row. Import the flat file into a table (perhaps as a single string column) and delete the last row. As Matt said, without more detail, it's tough to say what would work best.

Hi Matt In my case, the last row can be identified through a pattern, so I simply used the conditional split to filter it out. Thanks again, Salman Shehbaz,

It all depends on whether you can distinguish the trailer record from the other records. Here are a couple of solutions if you can't. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com