I have to come up with a SSIS package to tranform data from oracle database
to our sql server database. This oracle db is managed by a third party , I
have been given 10 views from oracle so I can extarct information I need.
How should I design my SSIS package? Do I have to have 10 different data
flows or there is an eaier way to run my 10 select statements from these
views?

Is there any article that can give me some ideas on how to design SSIS
packages to extract information from oracle?

Thanks a lot

You could of course use the Import/Export wizard to lot of the hard work
for you but essentially yes you or the wizard will be executing 10 *
extracts from Oracle (this could be 1 * Data Flow Task or 10 * Data Flow
tasks)


--


Regards


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"Fariba" <Fariba (AT) discussions (DOT) microsoft.com> wrote