Create a SSIS Package - To Copy data from Oracle to SQL Server

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 Design
1.Using SSIS 2005
  1. Drag a OleDB Source and point to your Oracle Database and select the table .
  2. Drag a lookup and select the SQL Server connection and point to its table .
  3. In columns tab join the common column and select the columns in the right hand side which you need to retrieve . Lookup
  4. Click on Configure Error output and select redirect row for the join column . Lookup
  5. Drag a Oledb Command and connect it to the error output from the lookup. 6.Write an insert statement in Oledb CommandOledbOledb
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 Problem. So posting this to help others who are in need of this.

Comments

Post a Comment

Popular posts from this blog

Error : ID4243: Could not create a SecurityToken.

For persons who worked on WIF Programming would encounter the following error, ID4243: Could not create a SecurityToken. A token was not found in the token cache and no cookie was found in the context We will be getting this error when the browser sends the cookie to the server and when sever validates the token and it fails then we may get this error. The end user can't do anything since the browser sends the token to the server always until the user manually clears the cookie from the browser. To handle this scenario we can srite the below list of code in the Global.asax.cs Basically, what it does is it will check for the excetion type and then it tries to sign out the user (delete the cookie informations) and redirect to the requested page. It is as simple as it is :) protected void Application_OnError() { var ex = Context.Error; if (!(ex is SecurityTokenException)) return; Context.ClearError(); if (FederatedAuthenticati...
Read more

MVC - Looping through the model properties from cshtml

When ever we are struck with the values being not properly filled in the model and need to print all the properties of the model or dto of the page then we can use the below lines of code to loop through the model or dto and write all the items in the page. foreach (var result in Model)             {                                   var type = result.GetType();                     var properties = type.GetProperties();                     <ul>                         @foreach (var property in properties)                         {                         <li>     ...
Read more