You are here: Re: How Import XML file in a table with trigger. « MsSQL Server « IT news, forums, messages
Re: How Import XML file in a table with trigger.

Posted by M6C on 05/14/07 12:53

On 13 mai, 18:25, Erland Sommarskog <esq...@sommarskog.se> wrote:
> M6C (roca.da...@gmail.com) writes:
> > Thank you, but i don't find any information about an option to fire
> > triggers.
> > I will continue to looking for more informations about XML bulk load
> > options.
>
> I looked in MSDN Library, and according to the topic "SQL Server XML Bulk
> Load Object Model", there is indeed aFireTriggersproperty. This is forSQLXML4.0. I don't have much experience ofSQLXML, butFireTriggersis not
> listed under "What's New in SQL 4.0", so I guess it was there in 3.0 as
> well.
>

In fact SQLXML 4.0 have a FileTriggers property. But i try this option
in SQLXML 3.0 and it's not available.
So i must upgrade my sql server to the 2005 version, to use it.
Thank you for your answers. Now i know the reason of this
comportement.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация