DTS Packages (.dtsx) and Automation through C#

I have spent the last couple of weeks going through about 15-20 different examples/tutorials on running DTS packages from inside a C# Windows app (and even asp.net). I must have a mental block, because I can't seem to make it click in my head. I have hundreds of DTS packages saved as .dtsx files. I can double click on them and run them perfectly. What I need to do is be able to run them conditionally from inside a windows app. Could anyone point me to a tutorial or example that could help me with this? I've even looked at some VB source to see if I could work it out, but I keep running up against a wall. I'd appreciate any help anyone can provide.

I just realized, if there is a better forum for me to post this in, please let me know that also.

DTS Package inside another DTS package....

I have a DTS Package called 'DTSMother'. There are twoDTS Package called
'DTSChild1', 'DTSChild2'. DTSChild1, DTSChild2 are called inside the DTS
Package DTSMother.
If I delete the DTSMother will the system delete the other two DTS packages
('DTSChild1', 'DTSChild2')?
SQL 2K.
Thanks,
Benjamin
No, each package needs to be deleted separately.
--Brian
(Please reply to the newsgroups only.)
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:euUCgCPpFHA.3304@.tk2msftngp13.phx.gbl...
>I have a DTS Package called 'DTSMother'. There are twoDTS Package called
> 'DTSChild1', 'DTSChild2'. DTSChild1, DTSChild2 are called inside the DTS
> Package DTSMother.
> If I delete the DTSMother will the system delete the other two DTS
> packages
> ('DTSChild1', 'DTSChild2')?
> SQL 2K.
> Thanks,
> Benjamin
>

DTS Package inside another DTS package....

I have a DTS Package called 'DTSMother'. There are twoDTS Package called
'DTSChild1', 'DTSChild2'. DTSChild1, DTSChild2 are called inside the DTS
Package DTSMother.
If I delete the DTSMother will the system delete the other two DTS packages
('DTSChild1', 'DTSChild2')?
SQL 2K.
Thanks,
BenjaminNo, each package needs to be deleted separately.
--
--Brian
(Please reply to the newsgroups only.)
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:euUCgCPpFHA.3304@.tk2msftngp13.phx.gbl...
>I have a DTS Package called 'DTSMother'. There are twoDTS Package called
> 'DTSChild1', 'DTSChild2'. DTSChild1, DTSChild2 are called inside the DTS
> Package DTSMother.
> If I delete the DTSMother will the system delete the other two DTS
> packages
> ('DTSChild1', 'DTSChild2')?
> SQL 2K.
> Thanks,
> Benjamin
>

DTS Package inside another DTS package....

I have a DTS Package called 'DTSMother'. There are twoDTS Package called
'DTSChild1', 'DTSChild2'. DTSChild1, DTSChild2 are called inside the DTS
Package DTSMother.
If I delete the DTSMother will the system delete the other two DTS packages
('DTSChild1', 'DTSChild2')?
SQL 2K.
Thanks,
BenjaminNo, each package needs to be deleted separately.
--Brian
(Please reply to the newsgroups only.)
"Benjamin Nethan" <BNethan@.hotmail.com> wrote in message
news:euUCgCPpFHA.3304@.tk2msftngp13.phx.gbl...
>I have a DTS Package called 'DTSMother'. There are twoDTS Package called
> 'DTSChild1', 'DTSChild2'. DTSChild1, DTSChild2 are called inside the DTS
> Package DTSMother.
> If I delete the DTSMother will the system delete the other two DTS
> packages
> ('DTSChild1', 'DTSChild2')?
> SQL 2K.
> Thanks,
> Benjamin
>

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