I've not set it up that way personally but, as per my earlier post, BOL says you can!

No, they don't both need to be running under the same account, but each account will need to have a login on the other server and the necessary privileges. ...

BOL could have answered your question with minimal effort but since you're being lazy and I'm feeling generous I'll copy and paste for you.

Under Windows Authentication, each server instance...

What is not the case?

Just a thought. Wouldn't it be easier to simply pull the entire file into a single staging table, and then manipulate it out of that table into whichever destination...

At the risk of being shot down in flames for trying to 'simplify'what I believe is going on (and this based on:

a) my prior knowledge

b) the considerable amount I have...

Edited to say: "Nothing"

Such passion for our topic!! It amused me to note that the original poster announced he'd got the answer he required 9 days ago now and has, presumably, gone off...

Lokesh Vij (8/22/2012)

---

I knew there is a limit of 1000 records. But got it wrong 🙁

Overlooked the question: Inserts start from 0 that makes the first statement to exceed this...

dan-572483 (8/21/2012)

---

Does Microsoft have a page where you could look up a name and confirm their certifications? Last time I was job hunting, I listed an old certification...

In basic terms a star-schema refers to the arrangement of multiple dimensions around a central fact. So, when talking about where to locate the dimension, the natural place for...

You could just disable the TCP/IP protocol?

Access to this new sub-folder seems, so far,...

If you specifically set the Network Protocol in the 'Connection Properties' of SSMS to be 'TCP/IP', do you still need the port?

If you connect via sqlcmd, do you need...

A database snapshot will always be transactionally consistent with its source database at the time of creation. Therefore the incomplete transaction will have to be rolled back in...