Friday, February 17, 2012

DTS Import/Export Wizard

I have a problem here with my DTS Import/Export Wizard, according to MSDN Library stated below,

[When creating a table using the DTS Import/Export Wizard or DTS Designer, the owner of a table created at the destination is the current user (generally the dbo), regardless of who the owner is at the source. ]

My concern here is if i have a source table of owner A, how can I default the owner of a table created at the destination is A. The problem here is i have more that 20 table of owner A to transfer and i don't want the default to be dbo and i have to go and change each and everyone. Please advice.The most logical solution :

Register the server in EM with the login A. All tables will now be created with owner as A|||Originally posted by Enigma
The most logical solution :

Register the server in EM with the login A. All tables will now be created with owner as A

I had tried this logical solution. And it still give me dbo instead of user name A.

I try to import/export within the same server and i register the server using user A.

Please revert. Thank you very much.

No comments:

Post a Comment