Re: which authentication mechanism should I use?

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

  • 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 ... >>I would ask myself why I was using ADO code inside DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS C#
    ... That DTS Package works ... >> public string serverName; ... >> private void InitializeComponent() ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS C#
    ... Looping through a global variable Rowset is the best way. ... DTS process. ... dts package if the package doesen't run. ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing a DTS package from ASP.NET
    ... Hey, I have company. ... See the thread 'DTS from ... > file in my own machine, only SQL Server in another machine. ... > approach to run this DTS package triggered by web? ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling DTS to run every hour Until text file is loaded
    ... trigger to auto-schedule a job. ... TargetServersRole has been denied execute permissions on the sproc. ... > existence of a file in DTS, and if not exit the package. ... > tweak the job schedule from inside the DTS package after the file has been ...
    (microsoft.public.sqlserver.dts)
Loading