DTS Programming. Reference to TransferLoginsTask

Hello,
I'm working on a C# application that uses the DTS object library via COM
interop. Until now it has been working nicely. Now I would like to get a
reference to what it seems a special task category: TransferLogin,
TranferJobs, etc.
The CustomTaskId I'm getting from those tasks are
OMWCustomTasks.OMWTransferLogins and similar. I can't find the definitions
for those objects. I'm referencing in my project custtask.DLL and dtspkg.DLL
.
Any info on this would be appreciated.
Regards
JoseHi Jos,
How odd, from my front-end app (Vb 6) I can see perfectly this task
instantiating dtspkg.dll
"DTSTask_OMWCustomTasks.OMWTransferLogins_1"
This task own three properties: All logins, Description, Name
Current location: Alicante (ES)
"Jos G" wrote:

> Hello,
> I'm working on a C# application that uses the DTS object library via COM
> interop. Until now it has been working nicely. Now I would like to get a
> reference to what it seems a special task category: TransferLogin,
> TranferJobs, etc.
> The CustomTaskId I'm getting from those tasks are
> OMWCustomTasks.OMWTransferLogins and similar. I can't find the definitions
> for those objects. I'm referencing in my project custtask.DLL and dtspkg.D
LL.
> Any info on this would be appreciated.
> Regards
> Jose
>|||Hi Enric,
I can get the task through PackageClass.Tasks collection too.
What I would like to do is to get a typed reference to that task. This is
what I'm doing with other kind of tasks:
DTS.SendMailTask myTask = (DTS.SendMailTask)task.CustomTask;
This way I should be able to get not only the AllLogins property but the
source and destination servers info.
"Enric" wrote:
> Hi Jos,
> How odd, from my front-end app (Vb 6) I can see perfectly this task
> instantiating dtspkg.dll
> "DTSTask_OMWCustomTasks.OMWTransferLogins_1"
> This task own three properties: All logins, Description, Name
> --
> Current location: Alicante (ES)
>
> "Jos G" wrote:
>|||Ok, I've found the library I was looking for: CDWTasks.dll
It contains the interface definitions. Browsing the properties of
OMWTransferLogins is not enough to get, for example, connection info. It is
retrieved calling a function.
Anyway thanks for your help.
Regards.
Jose
"Enric" <vtam13@.terra.es.(donotspam)> escribi en el mensaje
news:9FA95B0E-57CF-4EDC-B9B6-7F515A147331@.microsoft.com...
> Hi Jos,
> How odd, from my front-end app (Vb 6) I can see perfectly this task
> instantiating dtspkg.dll
> "DTSTask_OMWCustomTasks.OMWTransferLogins_1"
> This task own three properties: All logins, Description, Name
> --
> Current location: Alicante (ES)
>
> "Jos G" wrote:
>sqlsql

DTS points to Named Pipe or TCP/IP?

Hello all,
When I used DTS, I found out that network library pointed Named pipes at
Process Info in Current activity panel. As my understanding, the network
library should points TCP instead.
What does the network library point to when DTS is used?
Should that library point to TCP/IP?
Which one is faster Named Pipe or TCP/IP?
How can I change order?
Thanks in advance,
Do.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...nnect/200508/1
Network library used depends on the client and the server.
Look at the client network utility and the server network
utility.
TCP/IP would probably be preferred in most cases
TCP/IP is normally faster
Try changing the order of the protocols on the client where
the DTS package is executed. Or try creating a TCP/IP alias
using the client network utility.
-Sue
On Thu, 25 Aug 2005 15:29:54 GMT, "Do Park via
droptable.com" <forum@.droptable.com> wrote:

>Hello all,
>When I used DTS, I found out that network library pointed Named pipes at
>Process Info in Current activity panel. As my understanding, the network
>library should points TCP instead.
>What does the network library point to when DTS is used?
>Should that library point to TCP/IP?
>Which one is faster Named Pipe or TCP/IP?
>How can I change order?
>
>Thanks in advance,
>Do.

DTS points to Named Pipe or TCP/IP?

Hello all,
When I used DTS, I found out that network library pointed Named pipes at
Process Info in Current activity panel. As my understanding, the network
library should points TCP instead.
What does the network library point to when DTS is used?
Should that library point to TCP/IP?
Which one is faster Named Pipe or TCP/IP?
How can I change order?
Thanks in advance,
Do.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...onnect/200508/1Network library used depends on the client and the server.
Look at the client network utility and the server network
utility.
TCP/IP would probably be preferred in most cases
TCP/IP is normally faster
Try changing the order of the protocols on the client where
the DTS package is executed. Or try creating a TCP/IP alias
using the client network utility.
-Sue
On Thu, 25 Aug 2005 15:29:54 GMT, "Do Park via
droptable.com" <forum@.droptable.com> wrote:

>Hello all,
>When I used DTS, I found out that network library pointed Named pipes at
>Process Info in Current activity panel. As my understanding, the network
>library should points TCP instead.
>What does the network library point to when DTS is used?
>Should that library point to TCP/IP?
>Which one is faster Named Pipe or TCP/IP?
>How can I change order?
>
>Thanks in advance,
>Do.

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.