SSIS Package is copying empty row in excel

Question

I am using SSIS package to copy data from SQL DB to excel file. But the problem is while running this package some time is skiping the empty row in between and sometime not and every time the row # is different.

Can anyone help me.....?

Answer 1

Check this link http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/AB94CAF4-DA74-4DD4-9FF7-A6F57E950EE0
Maybe this will help you to solvethis problem.

Answer 2

Does your data change frequently?

In the Excel Destination Component, click New button to create a new destination sheet.

Answer 3

Hi Pawan,

Is the data in your db table is changing frequently or is it of same data type? Also have u defined any format(data) in excel sheet ?

Kindly put some example data, so that we can be clear on this and will be able to help you :)

---

Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com

Answer 4

Hi Rahul,

Thank you..

Yes, the data in my DB is changeing frequently with same data type.There is no formula in the excel.

Example:-

Screen shoot of excel:-

White one is the empty line which is coming in excel

and one more thing, inserting blank line is not coming after a specific records,it's coming randomly.

Thanks in Advance for your help.....

---

Pawan Gupta

Answer 5

Yes the data is changing frequently.

there is a SSIS package which is running in every 1 hour to update the excel.

---

Pawan Gupta

Answer 6

Hi Pawan,

The issue might caused by the data is changing frequently, I suggest you use a Conditional Split component to detect your "blank" rows and route them to an unused output.

For more information about how to use Conditional Split component, please see:
http://www.bimonkey.com/2009/06/the-conditional-split-transformation/

Thanks,
Eileen

Answer 7

Thank everybady for reply.

But still i will not get the resolution so any bady have any other resolution please share it will help me lot

Thanks In advance.

---

Pawan Gupta