Re: which authentication mechanism should I use?

Yes,I'd like to get a count of one table in my activeX code and then based
on that count I would execute different packages .then after executing each
package I should Insert into a table and when the package is done I'd like
to delete the record from database,with this mechanism I control that not 2
instances of the same package is run at the same time (because of some
restrictions I have).

I know that I can use "Execute SQL task" ,but the problem is that I can not
run this task from within my ActiveX ,I can only set its sql statement and
let t run in the normal workflow which is not what I want .I'd like to get
the result right away and use it in ActiveX script.

Makes sense?

Thanks
"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:eTRxjjBTFHA.2560@xxxxxxxxxxxxxxxxxxxxxxx
>I would ask myself why I was using ADO code inside DTS. Is there something
>DTS is not fulfilling?
>
> As for authentication. This is by far the best article
>
> http://support.microsoft.com/?kbid=269074
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "Ray5531" <RayAll@xxxxxxxxxxxx> wrote in message
> news:%23vkAjbBTFHA.1896@xxxxxxxxxxxxxxxxxxxxxxx
>>I have a bunch of Activexscripts in my DTS package This DTS package is
>>going to be schadulaed to run automatically .In my activeX code I use ADO
>>connections in those connection strings I used Integrated Security.Will it
>>be problematci when the DTS package becomes schaduled?
>>
>> Which type of authentication should I use for my ado codes?
>>
>> Thanks
>>
>
>


.

Relevant Pages

  • get package name
    ... Is it possible to determine the name of the DTS package, from within the package that's running? ... I have to edit the package name that's hard-coded in the email step and it dawned on me that there is probably a way to determine the package's name in ActiveX or some other way. ...
    (microsoft.public.sqlserver.dts)
  • Re: Using Python in ActiveX task - works when run as separate step
    ... I just used some simple script to test: ... I installed ActivePerl on my test machine, create a new DTS package, and a ... new ActiveX script task. ... |>>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • Re: importing xls file - different attempt - one result....
    ... Why not use the wizard to create the exact DTS package you need to import XLS files? ... Dim oConnection as DTS.Connection2 ... Dim oColumn As DTS.Column ...
    (microsoft.public.sqlserver.dts)
  • DTS Package remotely in batch file
    ... the package on the server. ... ECHO The execution of the DTS package has succeeded. ... DTSRun: Executing... ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: ActiveX Script errors suppressed
    ... I've never actually tried to call GetExecutionErrorInfo in an ActiveX ... >etc. ActiveX Script only has the variant type. ... >change the variant to a true string. ... Dynamic Properties task instead in the main package. ...
    (microsoft.public.sqlserver.dts)
Loading