DTS & Triggers

#1

The DTS service fetch 3 rows from a CSV file and insert to the tblTemp
table.

and in tblTemp there is a trigger which performs insert them to the tblMain.

when I insert a row direct to the tblTemp the trigger works ok.

but unfortunately when the DTS works the trigger is not working.

This process(DTS->tblTemp->tblMain) is due to some reasons. for example, PK
constraints.

Are there something that I missing?

TIA.

#2

Take off "fast load" on the last page of the datapump setup. Your trigger
should fire now.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"haode" <iamjhkang (AT) abc (DOT) com> wrote

Quote:

The DTS service fetch 3 rows from a CSV file and insert to the tblTemp
table.

and in tblTemp there is a trigger which performs insert them to the
tblMain.

when I insert a row direct to the tblTemp the trigger works ok.

but unfortunately when the DTS works the trigger is not working.

This process(DTS->tblTemp->tblMain) is due to some reasons. for example,
PK
constraints.

Are there something that I missing?

TIA.

#3

Thanks.
It did work.
BTW, is it suposed to be slow then?
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

Take off "fast load" on the last page of the datapump setup. Your trigger
should fire now.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"haode" <iamjhkang (AT) abc (DOT) com> wrote in message
news:%23QBJVIgyDHA.1804 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
The DTS service fetch 3 rows from a CSV file and insert to the tblTemp
table.

and in tblTemp there is a trigger which performs insert them to the
tblMain.

when I insert a row direct to the tblTemp the trigger works ok.

but unfortunately when the DTS works the trigger is not working.

This process(DTS->tblTemp->tblMain) is due to some reasons. for example,
PK
constraints.

Are there something that I missing?

TIA.

#4

Fast and slow can be relative terms <grin>
Test it for your performance.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"haode" <iamjhkang (AT) abc (DOT) com> wrote

Quote:

Thanks.
It did work.
BTW, is it suposed to be slow then?
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:ejSJkOgyDHA.2556 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Take off "fast load" on the last page of the datapump setup. Your
trigger
should fire now.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"haode" <iamjhkang (AT) abc (DOT) com> wrote in message
news:%23QBJVIgyDHA.1804 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
The DTS service fetch 3 rows from a CSV file and insert to the tblTemp
table.

and in tblTemp there is a trigger which performs insert them to the
tblMain.

when I insert a row direct to the tblTemp the trigger works ok.

but unfortunately when the DTS works the trigger is not working.

This process(DTS->tblTemp->tblMain) is due to some reasons. for
example,
PK
constraints.

Are there something that I missing?

TIA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS & Triggers

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS & Triggers - 12-24-2003 , 03:41 AM

Re: DTS & Triggers - 12-24-2003 , 03:54 AM

Re: DTS & Triggers - 12-25-2003 , 06:28 PM

Re: DTS & Triggers - 12-26-2003 , 01:32 AM