Now I have screwed up my computer and I can't connect to Oracle at all.

crap...

Okay I got it...mine is a little different...but I think it will be fine.

So I just un-installed my Oracle drivers and I am in the process of re-installing the new...

Okay in your scipt when you say ALias do you mean my TNSNAMES server alias or the name of my Linked server?

Hey thanks for the quick response 🙂

Okay so I downloaded and installed the Oracle 11 drivers on my local computer...and deleted my linked server and added a new one, and...

Well I think the account have been deleted ...so do you think it will work to recreate the account?

AWESOME!!!

Okay I just spoke with our Admin and he will activate the user tomorrow morning and I can try it.

Thank you.

Thanks..but he is no longer with the company and his machine has been wiped and is not available...can I open the package as XML in notepad and change that setting...

Error1Error loading ACCTG_ROLLUP_POSTER_2.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information....

Yeah...I know that would be simple...but the application uses ADO for ALL updates and passes the control through a generic base class...ugh.

-chris

Auto-statistics update is turned on.

I just did a rebuild on all my indexes that had more than 30% fragmentation.

I created the indexes with a T-SQL script...and the value is set to OFF...the default.