ntuser. didn't test sqluser.

Steve Jones

steve@dkranch.net

I don't see any way around either recreating or altering the application.

Steve Jones

steve@dkranch.net

I logged in as my user and it worked. Check the altuid column as well. I have a 1 here for my aliased user.

Steve Jones

steve@dkranch.net

I'd say DTS, script a Transform Data Task for each table.

BCP might work, but not sure how hard this is to setup the export from Oracle.

Steve Jones

steve@dkranch.net

what about isalias?

Which UID does the user have?

Does this user have a role? a sid?I added a domain user and ran sp_addalias and it seemed to work. Will log off...

It looks like you have two conflicting proceses. Can you explain what tasks are in the package and in what order they work?

Steve Jones

steve@dkranch.net

DMO Sucks!!!!!!!!!!!!1

Actually, I do agree with Andy somewhat. The best tool is the one to use. I do use EM in certain places that I can never remember the syntax....

select * from information_schema.columns

Steve Jones

steve@dkranch.net

Can you check sysusers and see what the entry is for this user?

Steve Jones

steve@dkranch.net

Thanks for the post and this is more clear.

It looks like you will want to build dyamic sql, where your stored procedure looks something like:

Set the variables:

@Key

@Variable

@Value

@DataType of Variable

@TargeTable

select @cmd...

Yikes, don't monitor those.

Thanks for the followup.

Steve Jones

steve@dkranch.net

do you have a key that includes data about where the data was entered? If you have the same key for both sources, you will have problems. You should have...

If you want to use DTS, I'd use andy's suggestion of FSO.

Either way, I'd get it out of the trigger and use some other process to move data often.

Steve Jones

steve@dkranch.net

np on the long post, but it doesn't make sense.

This is one table that gets a bunch of information, but what does the table look like? What columns?

Then something calls...

2000 of them?

Steve Jones

steve@dkranch.net