dbTalk Databases Forums  

Issue when we are creating a DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Issue when we are creating a DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Enric
 
Posts: n/a

Default Issue when we are creating a DTS - 06-29-2005 , 09:35 AM






Dear all,

We've created an specific user with Sysadmin role and after that, with that
same user we build a DTS but once saved in the server, appeared as 'owner'
the NT
user.

What's happening?

Any help will be welcomed.

Thanks in advance and regars,

Reply With Quote
  #2  
Old   
Helge C. Rutz
 
Posts: n/a

Default Re: Issue when we are creating a DTS - 06-29-2005 , 10:29 AM






Hi Enric,

"Enric" wrote:
Quote:
Dear all,
We've created an specific user with Sysadmin role and after that, with
that same user we build a DTS but once saved in the server, appeared
as 'owner' the NT
user.
this behaviour is by design, the designer always stores the windows user
name for the package as text string. Don't ask me why ;-)
It also stores the sid of the creator, which should direct to the corect
sql user.
Look here for some more informations to the package owner problems and how
to change it
http://www.sqldts.com/default.aspx?212

Helge



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.