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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy