Hello,
When I insert some data in table with DTS package, I get data in table but
after insert trigger don't fire.
I try insert data on some other server with same DTS package and situation
is the same.
When I made DTS package on some other server it work fine

It look like that is something wrong with package, trigger is very simple,
it OK
When I enter data form Enterprice manager or WEB interface or ... trigger
works fine
I work with MSSQL2000 sp3a and win2000 sp4

Thank you

Have you turned off FAST LOAD on the last tab of the datapump properties ?

--

----------------------------
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



"Aleksandar Perisic" <aleksandar.perisic (AT) apa (DOT) co.yu> wrote

Yes, I turn off fast load but situation is the same.

When I search google with - "trigger not fire" sql - I get some results
where I see that someone refer on collate in problem that trriger not
fire. Is it possible

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Can you give me the target table def + trigger?
What is the task that you are using to insert data ?

--

----------------------------
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



"Aleksandar Perisic" <aleksandar.perisic (AT) apa (DOT) co.yu> wrote

Here is a quick example for what I did

CREATE TABLE SourceForTrigger(col1 int)
CREATE TABLE TriggerDestination(col1 int)
CREATE TABLE TriggerCapture(col1 int, col2 smalldatetime default getdate())
GO
CREATE TRIGGER tr_Inserts ON dbo.TriggerDestination FOR INSERT
AS
INSERT TriggerCapture(col1)
SELECT col1 FROM INSERTED
GO
INSERT SourceForTrigger(col1) VALUES(1)
INSERT SourceForTrigger(col1) VALUES(2)

--DTS Package between SourceForTrigger and TriggerDestination
--Using a DataPump task turned off Fast Load

SELECT * FROM TriggerCapture

col1 col2
1 15/09/2003 12:21:00.000
2 15/09/2003 12:21:00.000



--

----------------------------
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

My fault!

I use to package A and B. A call B few times with different parameters.
I try to change in B everthing but trriger don't work. For this part you
now that already. But in package A, everytime when press save button on
package B, you must pick up the new version of package B. I forgot
pickup the new version of package B...

When I swich off fast load everything works fine...

THANK YOU ON YOUR TIME!

B.Sc. Perisic ALeksandar
Production Support
AD apatinska pivara
SCG

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!