December 15, 2001 at 1:39 pm
I'm importing IISLog files and it has the potential of error during import. Question I have if I detect an error can it not insert that row and move on? I want to continue processing the file and only on an error do I want to skip that particular record and move on. I'm new to this and the wizard is fine but I want to build logic into the Import process. Thanks!
December 15, 2001 at 1:40 pm
December 15, 2001 at 4:04 pm
December 15, 2001 at 5:07 pm
Considering I'd not used DTS more than 10 times before this weekend. I'm a asp programmer more than a db person but i'm assuming this setting is after the dts package is created and run the 1st time? i didn't see the transform errors out. Is this a setting how many to error out on before quiting all together?
December 15, 2001 at 8:20 pm
I figured this out, after I immediately ran the DTS package and it errored, i went into the designer and set the error threshold very high and all data imported. I'd like to have a VB Routine that will parse one of the columns as its being inserted but I'm sure that is a little bit more advanced for using a wizard based approach. thanks//
December 16, 2001 at 9:34 am
You are welcome and this is the number of error before it fails.
Techincally, I beleieve that these erors are omitted from the transaction count, but I'dhave to test it.
Thanks for the feedback and followup.
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply