By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,261 Members | 1,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,261 IT Pros & Developers. It's quick & easy.

DTS vs triggers

P: n/a
Hi,

I've got the following problem:

I'm using DTS to transfer fata from csv files into a table.
In the file there are often duplicated rows, therefore I made a
trigger
on the table.

The trigger works fine when i tried in query analyzer, but it not
launched
from the dts.

I've learned that i have to turn of the fast load option in the
properties of the transform data task object.
When I turn this option off, the task will fail with the following
message:

"The number of failing rows exceed the maximum specified.
Cursor operation conflict."

I wonder why this happens. There are no check constraints on the table
against duplication.

Thanks in advance for any help

Oct 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Bijesz wrote:
....

"The number of failing rows exceed the maximum specified.
Cursor operation conflict."

I wonder why this happens. There are no check constraints on the table
against duplication.


I may have an answer:

Let's assume you've saved your DTS job on the SQL Server, so that when
you are in Ent. Mgr. you can click on the DTS folder, click on the
'local packages' icon, and find your saved DTS job there.

Once there, you'll see the DTS job displayed as a set of 3 objects: 1)
the Excel icon for your source; 2) an arrow pointing to your MSSQL
destination, and; 3) your MSSQL destination.

If you right-click on the Excel or MSSQL objects and open the
Properties window, as I did, you'll be perplexed.

It finally occurred to me to right-click on that arrow and open-up yet
another Properties window there.

Once there, if you click on the 'Options' tab, you'll find a 'Max Error
Count' property. Nice place to hide it, eh?

hth,

victor dileo

Oct 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.