|
Home > Archive > MS SQL Server DTS > March 2006 > Keeping object selection when changing login
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Keeping object selection when changing login
|
|
| ksteilbe 2006-03-29, 1:29 pm |
| When I modify the server connection to change the login ID when I transfer a
DTS package to a different server, the tables I selected for copy on the
original package get de-selected. How can I preserve the object selection
when changing a connection login? This is in SQL Server 2000. Thanks for
any help!
--
Karen
| |
| ksteilbe 2006-03-29, 8:27 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
"ksteilbe" wrote:
> When I modify the server connection to change the login ID when I transfer a
> DTS package to a different server, the tables I selected for copy on the
> original package get de-selected. How can I preserve the object selection
> when changing a connection login? This is in SQL Server 2000. Thanks for
> any help!
> --
> Karen
| |
| Tomer Shoval 2006-03-29, 8:27 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.
| |
| ksteilbe 2006-03-30, 9:31 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
"Tomer Shoval" wrote:
> 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.
>
>
| |
| Tomer Shoval 2006-03-31, 8:26 pm |
| i'm sorry. the flags property is from another task.
in the "Copy SQL Server Objects" task, it's DestUseTrustedConnec
tion
and SourceUseTrustedConn
ection.
for SQL Server login, set it to 0
i just tried it, and it didn't forget my object selection.
|
|
|
|
|