Re: DTS - Triggers and Defaults Not Firing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/29/04 

Date: Sat, 29 May 2004 09:04:25 -0400

Right you are Allan. I can always count on you to clean up my mess<g>. 

-- 
Andrew J. Kelly
SQL Server MVP
"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?
> >
> >
>
>

Relevant Pages

  • Re: Types of locks occurring during Maintenance Plan
    ... Microsoft SQL Server Storage Engine ... > Thank you all for the quick responses, but neither foreign key or triggers ... >> Tibor Karaszi, SQL Server MVP ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: INSERT Problem
    ... >>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >>> INSERT Staging VALUES ...
    (microsoft.public.sqlserver.dts)
  • Re: Dynamically set up DTS Transformations?
    ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)> www.SQLDTS.com - The site for all your DTS needs. ... >> package each time but set the source table and destination text file ...
    (microsoft.public.sqlserver.dts)
  • Re: Recovering SQL Server 2000 database without a backup
    ... >>Andrew J. Kelly ... >>SQL Server MVP ... >>> database and I don't have a recent backup. ...
    (microsoft.public.sqlserver.tools)
  • Re: bcp
    ... >>> How to manipulate the Execute Process task. ... >>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)