Solved

SSIS SQL Source to Excel Destination not writing any rows

Posted on 2013-12-10
7
863 Views
Last Modified: 2016-02-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.

Regards,
John
0
Comment
Question by:j_heck
  • 3
  • 2
7 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39710680
Hi,
which SQL version?
Could you zip the package and attach it to this question?
Thanks.
Rainer
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39711139
>I do not get any data in the Excel spreadsheet.
Eyeball all of your Excel doc to make sure that is the case, as SSIS to Excel has some known issues where if a package previously inserted 100 rows, and you run it again, the output data will appear on row 101 and not row 1.
0
 

Author Comment

by:j_heck
ID: 39772181
I've requested that this question be deleted for the following reason:

I figured out what I was doing wrong.
0
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 65

Expert Comment

by:Jim Horn
ID: 39772182
>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.
0
 

Author Comment

by:j_heck
ID: 39830208
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.
0
 

Author Closing Comment

by:j_heck
ID: 39830215
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.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now