"haode" <iamjhkang@abc.com> wrote in message
news:%23QBJVIgyDHA.1804@TK2MSFTNGP09.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.
>
>

"haode" <iamjhkang@abc.com> wrote in message
news:Olb7ic0yDHA.1996@TK2MSFTNGP12.phx.gbl...
> Thanks.
> It did work.
> BTW, is it suposed to be slow then?
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:ejSJkOgyDHA.2556@TK2MSFTNGP10.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@abc.com> wrote in message
> > news:%23QBJVIgyDHA.1804@TK2MSFTNGP09.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.
> > >
> > >
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:ejSJkOgyDHA.2556@TK2MSFTNGP10.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@abc.com> wrote in message
> news:%23QBJVIgyDHA.1804@TK2MSFTNGP09.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.
> >
> >
>
>