Can the Bulk Insert Task in DTS be used with the FIRE_TRIGGERS hint? If
so, how? Or do you have to use an Execute SQL Task with the Bulk Insert
T-SQL command.


*** Sent via Developersdex http://www.developersdex.com ***

On Mon, 29 Aug 2005 13:39:39 -0700, SJM <nospam (AT) devdex (DOT) com> wrote:

I know of no way to do it. The only options you get are those listed on the options tab



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

Hmmm, that is unfortunate. I would have expected this functionality to
be available. Thanks for confirming this situation.

*** Sent via Developersdex http://www.developersdex.com ***