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.