Are you trying to access the local server?

Also, is SQL logging in as a user account or as something like localsystem?

CEWII

Da-Zeros answer is good. If you have a big package zoom out, select everything in the package, and then click disable, the re-zoom, and enable the one you want....

Why don't you execute it with the full command line and see exactly what is returned.

It might not be an error but I have seen it return something when it...

I would ask what messages are being returned, I'm pretty sure that if it doesn't use a file passed it will indicate why..

CEWII

That doesn't change the options.

To help zero in on the best choice, how do you intend to execute the package?

CEWII

I think that you will have to setup package logging.

From SQL Server 2005 Books Online (November 2008)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/3c74bba9-02b7-4bf5-bad5-19278b680730.htm

CEWII

You could setup package configurations and use expressions to change the servername in the connection string.

You can pass them in during the run as well.

CEWII

Well we could generate them but having to jump through hoops because a provider wasn't available is absurd.

When we switched from 32 to 64-bit sql this was one of the...

Right on Alvin, in the end all the schedulers or even SSIS server eventually call DTExec, so there is nothing preventing it from being called directly.

CEWII

This functionality is only about 5 years late.

They should have had this ready in 2005...

You guys have a good week.

CEWII

It depends, the old standby..

Depending on what you need to encrypt and the audience you need to keep it from defines a great deal about HOW and WHERE you do...

It is kind of convoluted when you search for it..

I believe this will get you what you want:

Access Database Engine 2010

Follow the link..

CEWII

I believe those are warnings, not errors but are indicative of memory pressure. You can turn up the buffer sizes, I believe there is a max of like 100MB....

I can think of a couple of reasons..

1. The SMTP server requires authentication, if so then the component can't be used since it doesn't support it.

2. There is an access...

This is my feeling as well. Although I think that the concern by Shark Energy is overstated. The new Chris Smith could potentially access to "sensitive" information provided...