Schema Check before ETL Loads

• SRINITHARUN2001

  Valued Member

  Points: 61

  More actions

  September 27, 2009 at 10:29 am

  #211421

  We have a requirement to compare the check and compare the source schema before starting our ETL process. I would like to see the options we have and the permisssions on database we require to do this.

  Thanks for your help in advance

  Srinivas

• Yaniv Mor

  SSC Eights!

  Points: 936

  More actions

  December 29, 2009 at 2:59 am

  #1096949

  If you're using SSIS, it validates the schema that is used in the package before running. I hope I got your question right.