Re: error number -1263.
Posted in 2003
Juan Ignacio Carbajal Rivera wrote: > Hello: > is there anyway to filter rows that fail to satisfy column type > so my load transaction doesn't stop? Have a look at using violations and diagnostics tables. That way you will have all valid records loaded into your table and all the invalid records in a another table waiting to be validated. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+