November 3, 2010 at 7:03 am
A text file is having about 3GB with a footer (containing record count and other details, but total row length shorter than other valid records), How do we handle that? I dont need to load the last line i.e. footer line into the original table(maybe to other new table is ok). But I need that footer to do various comparisons?
November 3, 2010 at 7:12 am
you could load all the data into a staging table,
and then from there load the data into the final destination without the footer row by using a where clause in your sql to exclude the footer based upon the data in it.
November 3, 2010 at 7:14 am
Yes steve, thas the approach i am currently using... i.e. using bulk insert. But is there any way to load/separate only the last line either through SQL query or in SSIS
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply