The drivers are here: http://www.microsoft.com/en-us/download/details.aspx?id=13255

CEWII

I'm reading that article now, the first thing I would say is the section where we set the debug setting Run64BitRuntime is ONLY applicable to BIDS, when the package is...

The error message tells the tale.

You are running it with the 64-bit run-time, unless you have the 64-bit jet drivers installed it will NEVER work this way. your choices...

Precisely my point, I looked back just to see if I missed it. That imformation would have changed the path suggested.

CEWII

Glad to hear you worked it out but I believe it would have been beneficial to state that a service pack was in play..

CEWII

So the issue is it can't connect to the SQL Server. I'm gonna be silly and ask whether you have verified that the SQL server is running..

If so then...

Sometimes this requires a full restart of the box, but I would check the eveny log to see if there is additional detail being logged such as a login failure.

CEWII

As far as item #1, I think that is included in most employee handbooks under conflicts of interests and ethical behaviors. Also I believe that for some of the...

There is a partial resolution which I don't like either.. But you encrypt the data fully at the front-end and only the encrypted data is stored in the database...

Yes they can, but you still haven't answered my post a couple up..

CEWII

Excellent point about over the wire, however if that is a concern you can force SQL to use an encrypted pipe, I've done it, it isn't TOO painful..

As...

In that case the names and scopes of the items being modified by the config file must all be the same otherwise it won't affect them. Also are the packages...

Thanks Lynn. I'll send it after bit.

CEWII

That sounds like a good idea. I have all the code and the paper and process already written, prettyfy it. I'll see what I can do..

CEWII

Yes, I use sprocs, but you pass in a value that is then hashed and then the hashed value is used to select the right key. So even the...