Post reply

Export Data to several SpreadSheet

  • September 10, 2008 at 12:11 am

    #192637

    hi,

    I have some questions about exporting data to Excel(2003).

    But what I am gonna do is complicated a little bit , which is to create sheet name by the kind of column value in database.

    if I have these data below....

    nationalily(column)

    american

    american

    japanese

    japanese

    chinese

    chinese

    ......

    I wanna name first sheet "american", second sheet "chinese", third sheet "japanese" in a excel file.

    Each sheet has their data in, and all the sheets are the same format.

    using SSIS, is this possile?

    does anyone please tell me or reffer some website how to do this?

    thank you,

    tomoko

  • September 10, 2008 at 1:00 am

    #869420

    This would be possible using a code (VB.NET for example) by getting the data, examining it and then chucking it into the appropriate worksheet. Using a script task in SSIS could do it.

    Not sure of any other method.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply