It seems that your column and row separators are ,. in this case you have to use a script components.

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

Many DBAs are saying that it is a good stable product.

Also, you can increase the retry attempts by modifying the relevant replication job

But before that include the logging as andy said. That log will give you the exact cause...

Congratulations Jacob . Keep up the good work

Andy,

is it possible you to do following changes in the article

SELECTSCOPE_IDENTITY() should be SELECT SCOPE_IDENTITY() in first example block.

In the last example block...

sorry for the query errors

if you want your tables to update from both sides use merge repl or else use trnasactional replication

Oh yes prices have changed. I wrote this review some times back, arround 2 months.

Downside of this tool, you can go to the red-gate site, there is a forum...

http://dineshasanka.spaces.live.com/blog/cns!22A79FCE82651673!241.entry

I had the same requirment some time back. I used the trigger option

yes third party tools are the best option for this.

apex and red-gaet also having same feature tool. Also, you need to have Full recovery option for the database

No I haven't heard of such a sp. Can you paster the log line

You can use SQL Packager of red-gate

are you sure youre mail server is working fine. check badmail folder to verify