Click here to Skip to main content
16,017,502 members
Please Sign up or sign in to vote.
3.40/5 (2 votes)
See more:
When i'm trying to load the data from Table to flatfile i'm getting blank row at last.
e.g.
1. i have one table with 9 rows.
2. i have used dataflow task(oledb source,flatfile destination)
3. I moved that 9 rows from table to flatfile
problems:-
When i open that file i was able to see that complete 9 rows, but i'm getting 10th with blank space.so i don't want to get the blank row at last.
Posted
Updated 11-Sep-13 2:05am
v3

1 solution

I got the same problem.

Let try this:

That is step by step remove bad row or last row if you want

http://geekswithblogs.net/Compudicted/archive/2011/02/15/ssis-technique-to-removeskip-trailer-andor-bad-data-row-in.aspx[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900