Very nice job Lowell, thanks!

Pretty clever dwain, thanks for your input!

Ya, that's why I thought I might ask to see if anyone has done it, or is up to the challenge.:crazy:

That works, thanks.

Thanks for your suggestions. Turns out that in although I had Database Mail XPs enabled, it also required SQL Mail XPs to be enabled.

Got it. Thanks for making sense of it for me.

Not sure I understand where you're saying to set that. It's not a script, using data flow objects. Thanks for the reply.

Yes, this is a developing environment - not production. That link doesn't really answer the question tho.

Lowell (3/20/2012)

---

a serverside trace for DML changes is very lightweight; if you have it rollover you won't have to worry too much about log file sizes,a nd it may help...

While I agree that limited access is the best answer, I just arrived and am trying to do just that. Until I sort out the security issues, how can...

Thanks Recurs1on!

ok. lets create 2 tables:

/****** Object: Table [dbo].[table0001] Script Date: 03/02/2012 15:13:34 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table0001]') AND type in...

I appreciate your input. For now it's 1 file a day and I require a bit more hand holding and granular steps. The file name looks like 02212012_test.xml....

I am seeing the preemptive_com_getdata wait also with a db2 ole linked server connection. Did you have any resolution?

1 more question: would the nc index fully exist in both files or equal/unequal portion on each?