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.
which SQL version?
Could you zip the package and attach it to this question?