what was the original Question? :w00t:

Q. What Version of SQL Do you have. 🙂

I have three Kids, one is very active and gets in trouble easily, the other is a very intelligent individual. he only see the world as black or white, finally...

Wait for it....

in rights what is higher, the domain or the local?

Try using not exists(= boolean) instead of not in(= iteration) 🙂

Q. Are they in the same domain, if not does one domain trust the other?

Done that already.

thanks

here are the possible answers

http://www.sqlservercentral.com/search/?q=The+SQL+Server+Integration+Services+service+failed+to+start+due+to+the+following+error%3A+&t=a&t=b&t=f&t=s

thnks SSCertifiable

solution:

I did as you suggested as found out it was the admin, when the system runs the tracer it creates the procedure and there it lies hiden, temp...

I have schedule no such job. 😉

a trace is correct. 🙂

I have Attempted that, with no luck. 😉

I am aware of that, the store procedure is created in the tempdb, but still does not answer the Question of how what and why is created or the Purpose...

Sorry.

the goal is to import the file directly to SQL, once in SQL I will proceed to Shred the xml part into one table and then populate other tables.

thanks

if y'all...

🙂

I am Not sure I understand the issue. are you pulling from the Database to populate a textbox in xml?

Help me understand so I may help you.

thanks