Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite
1

I'm new to SSIS and i want to generate an excel file from sql table.

sql table : mydata

Id    date       value
1     2013-02-2  236823
2     2013-02-3  185454

Now I need to generate and excel file which will gives me an input like

only date and value

how can i generate that excel file?

please give me any thread it would be great help.

I have tried to do start data flow task

inside i have taken ole db source and write sql query select date ,value from mydata

then added Excel destination ?

But it is giving me an error in excel destination : 

external table is not in expected format
share|improve this question
1  
Check this article cavemansblog.wordpress.com/2009/04/17/… –  praveen Mar 20 at 16:29
 
Excel connection manager part is missing ? I'm getting an error in excel destination : external table is not in expected format –  ashuthinks Mar 20 at 16:34
 
Is your Excel file open or r u using any password protected file ? –  praveen Mar 20 at 16:39
 
I want to create new excel file at location C:\test` and insert date,value` from sql table to excel file.. how can i do that? –  ashuthinks Mar 20 at 16:48

1 Answer

up vote 2 down vote accepted

My friend, what have you tried so far? This a simple click-click-click stuff. Next time, please share your effort. Here is the guidance:

1. Place a DFT on the Control Flow surface
2. Double-click on the DFT to enter into the Data Flow surface
3. Place an OLE DB Source. Double-click on it. Click on New... button and create a new OLE DB connection manager
4. Data access mode: Table or view. Select your table
5. Click on the columns. Select the fields you want.
6. Now place an Excel Destination. Connect it to the OLE DB Source.
7. Double-click and click on New... button. Give the Excel file path where you want to dump the data.
8. Click on New.. Some warning will appear. Accept it.
9. Select the Name of the Excel sheet from the drop down.
10. Run the package.

This is plain vanilla solution. Once you know the basics, polish your solution. For example, think about setting the connections through variables.

Good luck!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.