p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2 (http://p2p.wrox.com/book-professional-microsoft-sql-server-2008-integration-services-isbn-978-0-470-24795-2-422/)
-   -   Confusing Excel Issue (http://p2p.wrox.com/book-professional-microsoft-sql-server-2008-integration-services-isbn-978-0-470-24795-2/93712-confusing-excel-issue.html)

lazarus@ucc.edu October 16th, 2014 11:53 AM

Confusing Excel Issue
 
I have an SSIS package that creates Excel spreadsheets. I run an OLEDB procedure that previews fine but when I display my Excel sheet-the first 50 or so lines have nulls until the actual data displays.

Any ideas on how to fix this would be greatly appreciated.

Kian.ting May 29th, 2015 01:46 AM

Hi buddy,

I think you can use the "Derived Column" data flow transformation to format your data before writing it over to excel. It is taught in Chapter 8, if you do the exercise in chapter 8 you will know what I mean, hope this helps, I can see no one is answering question in forums anymore sighhhhhh ....


All times are GMT -4. The time now is 07:29 AM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.