Data Flow Error check data before inserting into db

• maximost1

  Mr or Mrs. 500

  Points: 515

  More actions

  April 17, 2009 at 11:14 am

  #208520

  Is there a tool I can use to review the data received in the flat file to make sure it is correct before I insert it into the db tables? For instance, what tool would I use to round a number to the nearest hundreth for the db table?

• maximost1

  Mr or Mrs. 500

  Points: 515

  More actions

  April 17, 2009 at 11:36 am

  #979878

  This appears to be the answer.

  http://www.programminghelp.com/database/sqlserver/sql-server-integration-services-script/