Post reply

How to copy data from multiple queries to same excel destination in ssis

  • November 28, 2013 at 4:20 am

    #1669656

    thanks a lot. That really worked. now i can proceed further.

  • November 28, 2013 at 5:06 am

    #1669662

    My select query will fetch me 2 rows. So what are the changes that should be made in ssis and vb code?

  • November 28, 2013 at 5:11 am

    #1669663

    suchitra.venkataramani (11/28/2013)

    My select query will fetch me 2 rows. So what are the changes that should be made in ssis and vb code?

    To do what, exactly?

  • November 28, 2013 at 5:13 am

    #1669664

    To be read and written to excel. Pls refer the above posts for more details.

    Thanks,

    Suchitra

  • November 28, 2013 at 5:26 am

    #1669666

    suchitra.venkataramani (11/28/2013)

    To be read and written to excel. Pls refer the above posts for more details.

    Thanks,

    Suchitra

    Why are you doing this in script? Use a dataflow.

  • December 3, 2013 at 10:06 pm

    #1670583

    Hi,

    Finally i was able to copy all the data from queries to single excel using VB Script and was able to format it as well with borders. Only thing i am facing is numeric data is stored as text in excel . i tried to change the format to numeric bit only when i press enter key only, data is stored as numeric. Pls help.

  • December 3, 2013 at 11:38 pm

    #1670598

    --Edit: comment removed.

  • December 4, 2013 at 6:35 am

    #1670693

    You could add derived columns for missing columns to each transformation to make then the output the same and then use SSIS UNION to produce a single dataset

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 8 posts - 16 through 23 (of 23 total)

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