Hi Micheal,

One of the approaches I have used is to make a dts package as the sql services domain account user. Then I save the package as a structured...

Have you tried putting parens around the whole expression before saving? I think it is wanting the full expression enclosed. Oh well, my suggestion.

Jody

GREAT have a really good weekend now!

Jody

Hi Curt,

The subtle key word here may be the 'configure' one. It is a sql server 'server setting'. You'll find it on the Connections tab of the properties...

No worries, Alex. That is what this community is all about. It is the little things that we find by our trials and errors that unlock problems for...

Sorry, I skipped a step and assumed (uh oh) that you already had established an nt login to sql.

In Enterprise Manager you can create a new login selecting the radial...

Thanks for the example. If you try your nt authentication again after setting the nt account in sql server to have 'sa' rights (enterprise manager to security to nt...

How do you have this bulk insert set up to run, command line or dts/sql job? If it is running from a command line the login to sql must...

Not very elaborate is it? As I think about it, I have had to reapply Office SR1 on a few occassions, never figured out why. Actually just stepped...

Good points there sherlock! I would not want to delve into changing load processes!

I wonder if there is an email account that has changed or one of the packages...

I got a sample proc from the scripts at this site. You need to have Microsoft SMTP service running on the server.

I also wonder if at the domain level...

Couple of items to check out:

1 - Do you have sql agent running as an nt user set with admin privileges on your server and the same login used for...

Ok, so how about versions. Have you installed sp1 and what version of mdac is currently on the server.

We had issues with another service being installed, think...

A while back we ran into connectivity issues that sound similar to what you are experiencing.

1. Have you installed more than once onto this server?

2. Have you installed more than...

Also, there is a gotcha if you are using auto identity on the originating table and expect to have that value available after the trigger has completed it's work. ...