Iam a new bie to SSIS and would like to create a SSIS package for autmating a manual process.I will list the manual steps theoritcally and would like to know how to accomlish this Steps 1)Read Data from Oracle Database 2)Compare each record that is read from the oracle database with multiple tables in a SQL database(Ex:Read each column of data from the source and then compare with a column in a table in the SQL database.) 3)Insert rows into a table in the SQL database if all the columns in each record found a match in the SQL server tables 4)Send the rest of the data that do not get inserted as a file as email I would like to have ideas to create this package Thanks

Here is help on the most hard part: comparing tables: http://geekswithblogs.net/Compudicted/archive/2011/07/13/cascading-if-else-elseif-a.k.a.-nested-if-else-statements-in-a-ssis-expression.aspx Connecting to Oracle - how to: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/1745db4e-7cea-414e-8a8d-1fb6e68b9c09 Attaching files to email: http://dwhanalytics.wordpress.com/2010/05/07/ssis-attach-multiples-files-in-send-mail-task/ Arthur My Blog

This to quite a standard process to use SSIS for, I recommend the book; - MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits) http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=SQL+Server+BI+MCTS&rh=n%3A283155%2Ck%3ASQL+Server+BI+MCTS&ajr=0 Chapters 1 to 4 of this book covers all your question.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood