Re: DTS Log file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Akber (Akber_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 03:41:04 -0700

Allan!
I can't understand your comment

"Allan Mitchell" wrote:

> What happens if you log then to SQL Server instead?
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Akber" <Akber@discussions.microsoft.com> wrote in message
> news:F60EA8F5-157C-4EE7-9340-98DCD4EEDD62@microsoft.com...
> > Hi,
> >
> > Is there any way that I can set in the DTS package to log information on
> > every step executed while it is executing.
> >
> > For example, I have a DTS package that has 12 SQL Execute tasks. The
> entire
> > DTS package takes 7 hrs to execute. I have set the looging option in the
> DTS
> > but the problem is that when I run this DTS Package as a job, it writes
> the
> > log file only after the job is finished executing. I want to know which
> steps
> > have been executed in the package while it is still executing as a job.
> >
> > --
> > Thanks
> > Akber.
>
>
>

Relevant Pages

  • DTS Log file
    ... Is there any way that I can set in the DTS package to log information on ... I have a DTS package that has 12 SQL Execute tasks. ... log file only after the job is finished executing. ...
    (microsoft.public.sqlserver.dts)
  • Re: copy a password protected dts package from one server to antoher
    ... You can certainly transfer it from A --> B but the issue will be around executing it. ... Allan Mitchell ... I have a dts package which is password protected, ... Is there anywhere to copy from SQL server to anotoher sql ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Remote DTS-Package on different Server
    ... That's the good thing about this method is the job has no schedule and is invoked by a user through sp_start_job ... Allan Mitchell ... thanks for your anser, i can not create a job on remote server, ... Maybe there is another possibility for executing this packet directly ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing a stored procedure in ActiveX
    ... what i want to do actually is, executing a bulk insert query. ... Stanley ... > Allan Mitchell MCSE,MCDBA, ... >> Is it possible to execute a stored procedure in aa ActiveX Script task in ...
    (microsoft.public.sqlserver.dts)
  • Re: activex dts job not saving promptly
    ... In the designer? ... Allan Mitchell ... executing and error out, then call it up again and find that it did not ... the changes to the script. ...
    (microsoft.public.sqlserver.dts)