Raj, I think the idea is that it's best to use the "supported" methods because if you have any "unsupported" coding in stored procedures or jobs, when that code is...

 " ........ Familiar Creep ...."

I thought you were talking about the guy upstairs in Accounting who's always bothering us !!!

Have you done rowcounts to confirm that the tables have the data they should ?  Also, it might be better to replicate from A -> B  and A-> C.  Then...

"When danger reared its uglu head, Sir Robin turned his tail & fled ......"    (pretty close I think)

I have fond memories of my Parents waking us up at 11:00 pm...

You could write a script to get counts of your publisher tables and subscription tables and check that the counts match

I could use a dose of magic from time to time !

Are you using ASP.NET, or "old" ASP ??     In ASP.NET, you can call the DTS, so that it's all part of the application. Write the DTS, then save it as...

DTS is set up to import "Comma",  "Tab", "Semicolon", or "Other"  (such as "pipe" or any other character)   Comma & Tab are quite common, so bringing in a .CSV or...

Adam, I think my post the other day was similar to what you encountered .... trying to separate different text records to be imported into SQL.  Richard Kemp responded and...

Just wondering .........

I ran the "TOP SQL CACHE" query listed above, and got results, but when & why would you run that ?  I'm not familiar enough with that data...

Depending on how you have it broken up, you could do your backups, then zip the .BAK files to save space.  Then perhaps you could keep more of them on...

That sounds like what I need !    Where do you run the FIND command from ?

As a test, I'm trying it from the Windows command line, but I can't get...

Would it be possible to fix the data, rather than back it out & reload it ?   When your "fixed" data comes in, join it to your live table and...

In BOL, under FIRE_TRIGGERS, ... "No result sets generated by the insert triggers are returned to the client performing the bulk copy operation." 

Is that relevant to what you hoped...

We have a third party application that seems to do deferred updates as part of their processing. I noticed this when analyzing the results of triggers from their replicated tables....