Tuesday, March 27, 2012

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

No comments:

Post a Comment