How to export sql table data into excel using C#, SSIS [Resolved]

Posted by vspsantu-21529 under C# on 4/2/2013 | Points: 10 | Views : 6852 | Status : [Member] | Replies : 4
Hi,

I am new to SSIS. Now i need to export table data into excel using asp.net, c# and SSIS package.

Please provide some real time examples.

Thanks in advance.

Santhosh P


Responses

Posted by: Jayakumars on: 4/2/2013 [Member] [MVP] Bronze | Points: 50

Up
0
Down

Resolved
hi
refer this

http://www.codeproject.com/Articles/402958/SSIS-Package-Export-Data-from-Database-Daily-to-Ne
http://stackoverflow.com/questions/9676710/import-export-data-from-sql-server-programmatically-using-c-sharp-and-asp-net

Mark as Answer if its helpful to you

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Satyapriyanayak on: 4/2/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
http://www.codeproject.com/Articles/368530/Dynamic-Excel-file-loading-with-SSIS
http://www.codeproject.com/Articles/301542/Creating-Excel-File-and-ExcelSheets-dynamically-fr
http://www.codeproject.com/Articles/301392/Import-Data-from-Excel-into-SQL-Server-Using-SSIS

If this post helps you mark it as answer
Thanks

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: vspsantu-21529 on: 4/2/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

Its very nice. If you have some other sample codes, please share with me.

Santhosh P

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/2/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
refer this

http://stackoverflow.com/questions/7506339/how-to-import-multiple-excel-columns-into-single-sql-server-column
http://brunofigueiredo.com/how-to-import-an-excel-sheet-into-multiple-sq
http://databases.about.com/od/sqlserver/a/Importing-And-Exporting-Data-With-Sql-Server-2012.htm


Mark as Answer if its helpful to you

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response