Audit task

Audit task

• Charoite

  Hi Jamie,

  I have a master database. Based on certain criteria's I will be creating one new database. Once I have finished the creation, I have to check the value of a particular column in both database tables.

  This is actually a status check. if both are not equal i have to update detail database table column value with master column value.

  I thought i can use lookup transform for this. The problem is master database table's status datatype and detail table's status datatype is diff.

  Can you suggest me any other way for this problem

  thanks in advance.

  
  

• Kris K

  No, the Audit component is NOT what you want here.

  To do the comparison use a MERGE JOIN to join the two tables together. Use a conditional split to get all the product IDs where the prices differ.

  Use the Rowcount component to count all the rows at various points in the flow. Once you have done that you will have all your required statistics available in SSIS variables - thereafter you can do what you like with them. A number of options here two of which are:

  1. Push them into a table which you can then report on
  2. Pass them out of the data-flow using a DataReader destination. A Reporting Services report can then read this data and report on it.

  Should be quite an interesting bit of work. Good luck!

  -Jamie

  
  
  

• Heydar

  Consider scenario like this.

   

  Two product tables are available product1 and product2. What i want to compare is the price field of two product tables for each product id

  if they are same no action

  if not do some action

   Hope I have made it clear.

   

  Regarding Audit report what i want is to report any error,warnings and

  Example :

  Records Added:  999,999

  Records Maintained:  999,999

  Records Inactivated:  999,999

   

  Is it possible to do with Audit Transform Editor

   

  
  

• moneppo

  You'll have to change the datatype in the pipeline prior to doing the LOOKUP. Try using a data conversion component.

  -Jamie

  
  
  

• nightowl03d

  How to compare values Well it depends what you want to do with them.

  How to view the report How about Reporting Services

  -Jamie

  
  
  
• Audit task