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

Question

Post reply

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

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

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

suchitra.venkataramani SSC-Addicted Points: 441 More actions · Answer 1

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

suchitra.venkataramani SSC-Addicted Points: 441 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 246965 More actions · Answer 3

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?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

suchitra.venkataramani SSC-Addicted Points: 441 More actions · Answer 4

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

Thanks,

Suchitra

Phil Parkin SSC Guru Points: 246965 More actions · Answer 5

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

suchitra.venkataramani SSC-Addicted Points: 441 More actions · Answer 6

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.

Phil Parkin SSC Guru Points: 246965 More actions · Answer 7

--Edit: comment removed.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

David Burrows SSC Guru Points: 65142 More actions · Answer 8

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.