hein-1120388 (4/20/2010)

---

Thanks. Seems a glaring hole in functionality though :/

I'll have to look at the firewall route for blocking the ranges, but then some clients connect from anywhere in the...

I think it shows as cancelled. But I completely agree it will die.

CEWII

I would echo what Lynn and bterraberry have said. Having a SQL Server open to the world is asking for trouble. You should have an idea of what...

I did a quick search to see if NT AUTHORITY\NetworkService would normally have enough rights to stop/start a service, but I didn't see any answers or anything pointing me that...

In general indexes increase SELECT performance but any kind of insert/update/delete activity requires the data AND index be modified so there is a cost there. So by taking the...

The item that struck me was "at my ISP". What it sounds like is that SQL does not run as a priviliged account (in the administrators group) and therefore...

While I agree with Brian, I challenge the requirement.

This is a lazy requirement in my book. In my experience it comes from fear and from someone reading a whitepaper...

The first thing that came to mind is that this might be a scheduled job and that other database maintenance tasks like re-orgs/re-indexes may have been conflicting either directly with...

So how is the parent package calling the child package. Also you said you know the filename is correct, is it hard coded?

Are the paths on your local the...

I am not sure how to get around that but you could send email from a Script Task directly. You might look at this code:

Code to send mail for...

Steve Jones - Editor (4/19/2010)

---

anthony_merriwether (4/19/2010)

---

This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you...

I don't view using a copy of the solution as important, but you might make sure that the copy was good.

As far as the verification.

In the Control Panel...

Ok, you have verified that the login used by SQL Agent has access not only to the path the package resides at but the package itself. You might consider...

I cant answer the question yet..

Is the package file located on the same server as the SQL Server?

CEWII

Sorry, I can't help you there.

I don't use that option.

CEWII