UPDATE:

After playing with everything I could think of yesterday...by the end of the day all the server Dbs were loging in & working.

Unfortunately I can't tell for the life of...

Yes...all the servers are up & running.

I can log into each one.

I have SQL set for both SQL & windows auth.

My end goal is to display db data...

All machines are Win2003 standard server...

Now to make matters more strange...over the weekend I've lost the connection through Enterprise Manager as well !:w00t:

Okay...I see what your saying now....the "sa" still exist under securites but under the db users... a blank dbo acct is in the list...it was "sa" once upon a time.

I...

I don't think you understand...THERE IS NO "SA"...that's my problem!

I need a way to fillin the login name "sa" on the dbo account...

Thanks for the effort!

Yes...all the connections are setup & ready to go in a DTS package. I'm now at the point of pumping filtered data from the remote Oracle db to my local SQL2k...

Thanks PW....with a couple a alias added, it appeared to have worked but it'll take some time to verify it worked correctly...thx for your input...its another option to play with...

The order numbers are listed in the MAIN_TBL. Thats why I INNER JOIN it with the remote table so the subquery only pulls dates for those listed in the MAIN_TBL....

I don't think security is the problem...I'm running the package from within the package while its open. I'm also executing steps that fail in the package. thanks though...

Let me try to explain what I'm doing a little better.

I have a spreadsheet named Template.xls which is already setup with the table names.

There will be many spreadsheets created when...

I found the problem...and I think its of the gotcha type...maybe a bug.

When I setup the connections in DTS, SQLserver said "Oh I have a big text column here so...

Theres nothing special about the spreadsheet...I'm only writing 8 columns to it...and so far I've run into a wall with this problem trying to move very little text. One paragraph...

That did the trick guys! Thx for all your help!

Enthusiast don't sweat the "tlog" that was my fault I typed it in by mistake.

I've put the UNC path in the plan so I'll let you know how that goes....

Yep!

Backup database master

TO DISK = 'F:\SQLBkups\BAKs\master_test.BAK'

this worked locally & remotely but the job is still failing.