Conflict Resolution

Is it possible to have a message or notification if/when conflicts occur?
Is this art of any standard resolver or does this require a custom resolver
to be created?
TIA
Tony S.
Tony,
you could use a custom resolver or regularly poll the conflict table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul
Tony S.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23dijkUCxFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Tony,
> you could use a custom resolver or regularly poll the conflict table.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Hi Paul,
Is there only one conflict table or one conflict table per db table ?
Is the conflict table stored in the SQLCE db or only at the SQL2000 DB ?
Thank you for your time
Panayotis
Paul Ibison wrote:
> Tony,
> you could use a custom resolver or regularly poll the conflict table.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Panos,
there'll be one per table in the format:
conflict_<PublicationName>_<ArticleName>_usertable name
These tables are stored at the publisher.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Confirmation on Script Task Behavior

Hello,

I am looking for some confirmation on a behavior of the SSIS Script Task. I have a custom script task that takes an input file, and archives it after it has been processed into the database.

When I run this package in the Visual Studio GUI, if the destination drive is full, it throws an exception telling me that there is not enough disk space. So, my questions are:

1) If this happens when the package is running through the command line, would this exception still be thrown? (I am thinking it will be)

2) Also, Do I need to explicitly fail the script task in the event handler, in order to ensure this .Net exception being thrown will cause the component to fail. (I am fairly certain I do, since this is what I had to do inside of the Visual Studio GUI, but does anyone know if this same behavior would occur when running from the command line?)

Thanks,

Chris

If you don't catch the exception, it should cause your script task to fail. Otherwise, you would need to explicitly fail it by setting Dts.TaskResult=Dts.Results.Failure. The exception-related behavior will be the same between the GUI and the command-line.