sql server dts: Keeping object selection when changing login -- sql server dts

RE: Keeping object selection when changing login

ksteilbe
3/29/2006 12:09:02 PM

I should add that the login is a SQL Server-authenticated ID. The problem
happens whether I change the ID to another SQL ID or to Windows
authentication.
--
Karen

[quoted text, click to view]

Re: Keeping object selection when changing login

Tomer Shoval
3/29/2006 5:08:32 PM

you should use disconnected edit to change the user id.

right click somewhere in the package, when no object is in focus, and
click disconnected edit.

look under connections for the connection you wish to change, or under
tasks for the task you wish to change.
you can change the password too.

if i'm not mistaken, to switch to sql authentication you have to change
the flags property value from 256 to 0.

Re: Keeping object selection when changing login

ksteilbe
3/30/2006 6:48:02 AM

Using disconnected edit allowed me to change the user ID, but when I saved
the package the object selection disappeared again.
Where do I find the flags property and how do I change it?

Thanks,
--
Karen

[quoted text, click to view]

Re: Keeping object selection when changing login

Tomer Shoval
3/31/2006 1:44:11 PM

i'm sorry. the flags property is from another task.
in the "Copy SQL Server Objects" task, it's DestUseTrustedConnection
and SourceUseTrustedConnection.
for SQL Server login, set it to 0

i just tried it, and it didn't forget my object selection.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.