asked on

SSIS SQL Source to Excel Destination not writing any rows

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.

Regards,
John

Rainer Jeschor

Hi,
which SQL version?
Could you zip the package and attach it to this question?
Thanks.
Rainer

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

j_heck

ASKER

I've requested that this question be deleted for the following reason:

I figured out what I was doing wrong.

Jim Horn

>I figured out what I was doing wrong.
For the benefit of future experts in your situation, spell out what you were doing wrong here.

j_heck

ASKER

You are right Jim, I apologize for not giving the resolution. It was a file naming problem with the file it was being written to in the Excel Destination. The incorrect sheet was being written to. This was still giving me problems so for the time being I switched it tow write to a CSV file using the Flat File Destination and the Flat File Connection Manager.

j_heck

ASKER

Jim you got me looking more closely at the Excel Destination and I did switch to using a Flat File Destination for the time being. Thanks.