All mentioned services are listed and started.

From the server.

I sorry.

The first statement is correct. Only for Client.

The server configuration does not have anything under this node.

Jason

How do I create a linked server?

I've never done that before.

Thanks.

Jason

Yes. for both Network and Client Configuration.

These are the options in the Configuration Manager:

* SQL Server 2005 Services

nothing under this node

* SQL Server 2005 Network Configuration (32 bit)

nothing under...

Named Pipes and TCP/IP are both enabled.

Yes I have sysadmin access and access to to 'sa'.

Let me clarify:

When I try to open Surface Area configuration, I get a "Named Pipes provider error 40 - could not...

I don't have Visual Studio .NET

I'm not going to run this automatically. I want this to run when the user wants it to run.

I'm not a .NET developer. So creating an ASP.Net page to do this is a little beyond my knowledge.

Can this be done without .NET such as through a batch file...

OK...

I'll need to delete the data currently in the SQL table and reimport from an excel file weekly. There will be over 1500 records in the excel file.

I want the...

The server won't let me even open the Surface Area Configuration.

OK...I modified the script to call:

dtexec /f "H:\FedExPH.dtsx"

And I receive the following error:

Microsoft Windows XP [Version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

H:\>FedExPH

H:\>dtexec /f "H:\FedEx.dtsx"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06...

Using sqlcmd, do I need to pass username and password for the SQL server?