Michael L John,

I'm just trying to create the Publisher/Distributor on the first box.  The error is happening when I attempt to create the Publisher/Distributor.

From my experience in the past.the subscriber part...

Steve Jones - Editor (12/10/2009)

---

I think Pavel is right. It has to be security. domain admins don't necessarily have rights to all folders.

What I'd suggest is you make a new...

Pavel Pawlowski (12/10/2009)

---

If you are able to login to the SQL server machine under the account under which the instance is running, then try to login and try access the...

Steve,

Sorry about the copy and paste, I didn't relalize there was a qoute button. Like I stated in my first post, I'm attempting to run this from a vb.net...

Andrew,

"I am sure that using VB.NET, you have some code that can read the files in the directory and come back with all the file names. Am I correct?" ...

"Does the file name change according to a pattern (date, etc)? Can you calculate it? If so you can use scripts to calculate the name and change the import path...

Maybe it would be best if I pasted the code so you understand what I am talking about.

Sub M_AO()

...

Steve,

The administrator account is the Domain Administrator account not the local machine account. Unfortunately moving the file from the remote pc to the SQL Server PC is not an...

Andrew,

I will take a look at the Books. I do have one question though, the file names change very day based on the day. example: ABC_20091210.xml tomorrow, ABC_20091211.xml....

"You should also use an SSIS package for things like this."

Andrew,

There's the problem I have 4 total imports that need to be brought in, so what I have is...

Pavel Pawlowski

"You have to run the SQL server instance under an account which has access and appropriate rights to the remote PC.

If you will run it under such...