<soapbox>

They have a bug, they fix the bug, modifying the SYSTEM databases to fix THEIR problem is unacceptable.

It might be possible, and even if it is I still wouldn't even...

Ok, that is wierd. I've not heard of services disappearing like this.

Did the AD domain change or just the address it exists in..

I have to admit...

I've spent some time in the script task and I think this is tied to the fact that your are effectively working with a buffer and you are modifying the...

I'm confused, you say it only has SSRS on it, if that is true you shouldn't see the other services.

What are the file dates on those files?

CEWII

Ok, Steve beat me to it..

CEWII

For as close to real-time as you can really get you can look at database mirroring. For near real-time you really have to go with transactional replication or log-shipping....

I think you are screwed.. I looked at the available system variables associated with items within a dataflow and tried several different data-flow components, not one idenitified itself by...

neilnewton001 (6/9/2010)

---

The password I'm discussing is saved in the oledb connection to the sql server database, not the connection for the excel spreadsheet. The excel spreadsheet isn't password protected. I'm...

I'm going along with what the other posters are saying, with a twist..

Grant makes a great point about how the data is accessed, usually not from a single table.

My twist...

Although this sounds like homework I'll answer anyway..

Your first question is about what ISN'T obtained, and the answer is nothing I can think of. However that begs the question...

Considering SQL 2000 is end of life (officially I think) I don't think this is where you should start. It might be nice for reference but you ABSOLUTELY shouldn't...

It isn't supported:

http://msdn.microsoft.com/en-us/library/ms139836.aspx

Important line:

You cannot connect to a password-protected Excel file.

Sorry..

CEWII

How are you using bcp then? How did it get installed on that server?

Since you would have to have the SQL drivers installed I would use the Client Network...

Although not pleasant an archival strategy should be considered early on and in many cases it would be better to be in a seperate database. I can give a...

Is this a named instance? Or just a non-standard port?

Have you tried servername\instancename?

You MIGHT setup an alias in client network config and point localhost as servername and port or...