Hi,

Please tell me whether its possible to open dts package using activeX
scripts(written in VB,js etc.) or by some other means but not thru Enterprise
manager directly. I need to specify logfile in each package on one of our
server. There are hundreds of packages on this server.

Please tell me how I can accomplish this task without manually opening and
editing each package under enterprise manager.

Thanks in advance,
Manu

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote:

Manu,

Yes it is possible to do this and there are many examples around the
'net. The only issue is that the layout of the package will be lost
when it is saved outside the designer. If the layout is not important
then proceed.

An alternative would be to set the log file on the DTSRUN command at
the job level.

from DTSRUN /?
Package operation (overrides stored Package settings):
/~A Global Variable Name:typeid=Value <may quote entire string
(in...
/~L Log file name
/~W Write Completion Status to Windows Event Log <True or False>

You could easily write a query to update the jobsteps to modify the
command column to add the /~L<file path>.

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/

On Mar 21, 5:02 pm, manu <m... (AT) discussions (DOT) microsoft.com> wrote: