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 Packages and Image/Binary/Blob data

I am trying to build a DTS pacakage that will create the database structure our application uses for our clients. The biggest problem I am having is when it comes to the reports, which we've stored as Image data in the database. During run time we get chunks to get the report out of the database. Has anyone tried and been successfull as using a DTS package to load binary/image data into a SQL table? My preference would be to use a global variable in the package to hold the location where the files are stored, and have them pulled in to their respective tables & fields when the package runs.
Any one have any ideas?
I've tried several resources, with no luck.Look for textcopy.exe on the web. Call a procedure from your DTS Package that will execute the following :

EXEC master.dbo.xp_cmdshell 'textcopy.exe -S ' + @.srvname +
' -U ' + @.login +
' -P ' + @.password +
' -D ' + @.dbname +
' -T ' + @.tbname +
' -C ' + @.colname +
' -W "' + @.whereclause +
'" -F "' + @.filename +
'" -' + @.direction

Ryan

DTS package

Is there some way we can allow users to run DTS packages through an
application without sysadmin privilege?You could use the DTS object model and do a
YourPackageObject.LoadFromServer
and
YourPackageObject.Execute
and then clean up your objects.
You can find examples at:
http://www.sqldts.com/default.aspx?104
-Sue
On Wed, 14 Sep 2005 17:21:03 -0700, "Eli Milkova"
<EliMilkova@.discussions.microsoft.com> wrote:
>Is there some way we can allow users to run DTS packages through an
>application without sysadmin privilege?|||But to use sp_OAcreate and sp_OAmethod sysadmin membership is needed. what I
am missing?
"Sue Hoegemeier" wrote:
> You could use the DTS object model and do a
> YourPackageObject.LoadFromServer
> and
> YourPackageObject.Execute
> and then clean up your objects.
> You can find examples at:
> http://www.sqldts.com/default.aspx?104
> -Sue
> On Wed, 14 Sep 2005 17:21:03 -0700, "Eli Milkova"
> <EliMilkova@.discussions.microsoft.com> wrote:
> >Is there some way we can allow users to run DTS packages through an
> >application without sysadmin privilege?
>

DTS in ASP.NET

Hi all,

I want to execute a DTS Package in a ASP.VB.NET(ASP.NET using VB language) application. Please, it's ASP.VB.NET(ASP.NET using VB language)

NOT VB.NET ou CS.NET

If it's possible i would like some code samples.

I'll be thankful if someone help me

Regards

Renatacheckthis article out.