SSIS SQL Source to Excel Destination not writing any rows
Posted on 2013-12-10
Hello, I have a simple SSIS package that has two items in the data flow, OLE DB Source & Excel Destination. They are connected and I get no errors when I run the package however, I do not get any data in the Excel spreadsheet. Though the Execution Results says that 1 row has been written. I have declared the first row in the Excel spreadsheet as the header row and it has the name of the columns in it. I get one row as a result from my SQL Query which is fine. But nothing shows up in Excel and I am completely lost at this point over it.
Any ideas or suggestions as to what to look at is greatly appreciated.