"Louis Ritchie" <anonymous@discussions.microsoft.com> wrote in message
news:E9C3079A-6993-4677-8650-AEFCB5C96F0C@microsoft.com...
> I'm loaing data using DTS (Excel to SQL 2000). There are triggers and

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:u$hI4hSREHA.620@TK2MSFTNGP10.phx.gbl...
> Bulk loads by default do not fire triggers, constraints etc. and do not
load
> default values. In the options of the transformation task you need to
> specify to Keep NULL values and what ever else is relevant.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "Louis Ritchie" <anonymous@discussions.microsoft.com> wrote in message
> news:E9C3079A-6993-4677-8650-AEFCB5C96F0C@microsoft.com...
> > I'm loaing data using DTS (Excel to SQL 2000). There are triggers and
> defaults on the tables being loaded. The columns are nullable that are to
> be updated via insert and update triggers. After the load, the columns
have
> nulls. I'm copying colum from Excel to column into DB. When I update the
> tables using DML, the triggers and defaults work as expected. Why are the
> triggers and defaults not firing?
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uq3n94TREHA.1448@TK2MSFTNGP11.phx.gbl...
> And that option is to uncheck "use fast load"
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:u$hI4hSREHA.620@TK2MSFTNGP10.phx.gbl...
> > Bulk loads by default do not fire triggers, constraints etc. and do not
> load
> > default values. In the options of the transformation task you need to
> > specify to Keep NULL values and what ever else is relevant.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Louis Ritchie" <anonymous@discussions.microsoft.com> wrote in message
> > news:E9C3079A-6993-4677-8650-AEFCB5C96F0C@microsoft.com...
> > > I'm loaing data using DTS (Excel to SQL 2000). There are triggers and
> > defaults on the tables being loaded. The columns are nullable that are
to
> > be updated via insert and update triggers. After the load, the columns
> have
> > nulls. I'm copying colum from Excel to column into DB. When I update
the
> > tables using DML, the triggers and defaults work as expected. Why are
the
> > triggers and defaults not firing?
> >
> >
>
>