tagging

Technical Article

RE: Primary key / DTS load question

  • Reply

Also, you might look into the Transform Data Task Properties - Option tab. It has a couple of features that deal with errors during a transform. Click the help button for that tab. Specifically I'm referring to the "Max Error Count" and "Insert Batch Size" which in combo allow a certain number of errors to […]

You rated this post out of 5. Change rating

2003-06-09

1 reads

Technical Article

RE: Primary key / DTS load question

  • Reply

Use exception handling in DTS. SQL Server 2000 provides much better exception handling than SQL Server 7. I've run into this problem several times where a mainframe extract writes the same record more than once, because something changed while the mainframe extract was running.

You rated this post out of 5. Change rating

2003-06-09

2 reads

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers