Badri's Technical Blogs

You should use Lookup to join the common column( same data type) of SQL server and Oracle and retrieve the values from Oracle which does not have a matching record in SQL server. Design  1.Using SSIS 2005 Drag a OleDB Source and point to your Oracle Database and select the table . Drag a lookup and select the SQL Server connection and point to its table . In columns tab join the common column and select the columns in the right hand side which you need to retrieve .  Click on Configure Error output and select redirect row for the join column .  Drag a Oledb Command and connect it to the error output from the lookup. 6.Write an insert statement in Oledb Command 2.If you are using SSIS 2008 then no need to configure the Error Output in lookup .Just drag the no match output from Lookup to SQL Server destination. Note: The same question I have asked in the http://stackoverflow.com and I got this response some years back and that helped me to solve my P...

Hello All, On a Friday morning every one plan for the weekend, Yes even I did the same and decided to Start a Blog. Blog??? What to write is the next question it comes to my mind... Yes of course whatever I am passionate about that, I need to write. Then I listed down what I am passionate about and the list was growing like something... Then I finally decided to write Blogs to help others as well as myself by writing my own challenging work experiences which I face day to day in my Work. Tired of reading my History of My Blogging... Let's go on to the real Blogs...