Tuesday, July 17, 2012 11:57 AM
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.....?
Tuesday, July 17, 2012 12:55 PM
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.
Tuesday, July 17, 2012 1:03 PM
Does your data change frequently?
In the Excel Destination Component, click New button to create a new destination sheet.
Tuesday, July 17, 2012 1:36 PM
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
Friday, July 20, 2012 8:39 AM
Yes, the data in my DB is changeing frequently with same data type.There is no formula in the excel.
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.....
- Edited by Pawan Gupta 26 Friday, July 20, 2012 12:25 PM
Friday, July 20, 2012 8:41 AM
Yes the data is changing frequently.
there is a SSIS package which is running in every 1 hour to update the excel.
Tuesday, July 24, 2012 8:55 AMModerator
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:
Friday, July 27, 2012 11:59 AM
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.