Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Export data to Excel

Author  Topic 

vani_r14
Starting Member

24 Posts

Posted - 2010-01-30 : 22:31:21
hi all

i am trying to export data from a table into excel or flat file using SSIS. I have a created a table called Person_Details
with three columns -

Name place Dob
XX Tokyo 4/12/84
YY Tokyo 9/4/76
ZZ Tokyo 6/3/70
HH Tokyo 30/3/65


I would like to save the details so each row is saved as an excel file. I have managed to create it so all details are saved into 1 excel file. I need some help. Can someone please help

thanks
   

- Advertisement -