Re: which authentication mechanism should I use?

Not really.

You can assign the return value from your

SELECT COUNT(*).......

to a Global Variable and use it.

You then use Workflow to decide what to do after that.

--

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:Od39XrBTFHA.580@xxxxxxxxxxxxxxxxxxxxxxx
> 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

  • ActiveX Scripting Error 2147220482 (800403FE) in DTS package..
    ... I have a DTS package that is run from a web UI via xp_cmdshell and DTSRUN, ... I'm getting an Active X script error on one of my steps only when run ... Error string: ActiveX Scripting ... ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Process Cube Task
    ... It has a command-line interface -- so you would use a DTS Process Task ... private dimension that contained more than 2 million members. ... occasionally the cube would process, and that was throwing me off. ... DTSRUN of the package from the command-line. ...
    (microsoft.public.sqlserver.olap)
  • Re: Is there a limitation on the number of Tasks that can Run in Parellel ?
    ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... >> Before the sending the mail yesterday, I did increase the number of Tasks executed in Parallel to 20 in the DTS Package>> Properties window. ... >> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep ... Step Error code: 80040428 Step Error Help>> File:sqldts80.hlp Step Error Help Context ID:1100>> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep>> 'DTSStep_DTSDataPumpTask_10' failed with the following error: OleDBProperty 'General Timeout' already exists in the collection. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Hanged When Scheduled
    ... Please feel free to respond to the newsgroups if you need any ... Microsoft Online Support ... | Subject: RE: DTS Hanged When Scheduled ... this behavior occurs because the package is using ...
    (microsoft.public.sqlserver.dts)
  • Re: Import and Schedule DTS on MSDE
    ... The dtsrun utility executes a package created using Data Transformation Services. ... Displays the command prompt options. ... Displays the encrypted command used to execute the DTS package without executing it. ...
    (microsoft.public.sqlserver.tools)
Loading