DTS Package - Zip Output File

Does anyone know if I can write a command inside of a DTS package to
zip the text output file?
Thank you!
Angie"angela.y.austin@.gmail.com" wrote:
> Does anyone know if I can write a command inside of a DTS package to
> zip the text output file?
> Thank you!
> Angie
>
Hi Angie
You can always use a SQL task to run xp_cmdshell and invoke the command line
version of winzip! If you have larger files you may want to run winrar
instead.
John

DTS Package

Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>

DTS Package

Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
Niraj
How do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegr oups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>
|||I launch the dts package by sql server agent
|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegr oups.com...
>I launch the dts package by sql server agent
>

DTS Package

Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>