Re: DTS - Triggers and Defaults Not Firing

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/29/04 

Date: Sat, 29 May 2004 06:37:12 +0100

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

Relevant Pages