 | |
Execute Package Task
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Execute Package Task -
10-22-2004
, 10:35 AM
#2
| |||
| |||
|
|
Hello. I have a large daily interface that I decided to break down into multiple packages for ease of understanding. There's one package for each system I extract from. Is there a way to have a package scheduled in the database return a value (true or false for success) to the calling package? I'm looking for a 'native' way to return variables from the executing package to the calling package similar to how the calling package can pass parameters to the executing package. I'd rather not write scripts that read text files for the purposes of returning that value if at all possible. It just seems like there should be a way to do this natively. Thanks for any help! -Brad |
#3
| |||
| |||
|
|
If you want ultimate flexibility over what happens then call the package from central package using the DTS object model. You can then easily read/write between the twn-n packages. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Brad" <Brad (AT) discussions (DOT) microsoft.com> wrote in message news:6C7EBF46-B29D-4446-96AD-5AF699FAE43F (AT) microsoft (DOT) com... Hello. I have a large daily interface that I decided to break down into multiple packages for ease of understanding. There's one package for each system I extract from. Is there a way to have a package scheduled in the database return a value (true or false for success) to the calling package? I'm looking for a 'native' way to return variables from the executing package to the calling package similar to how the calling package can pass parameters to the executing package. I'd rather not write scripts that read text files for the purposes of returning that value if at all possible. It just seems like there should be a way to do this natively. Thanks for any help! -Brad |
#4
| |||
| |||
|
|
Thank you Allan, that makes perfect sense. So now I just need to find out how to execute a package from an ActiveX script task. I haven't had a need to use the dts com yet. Thanks again. -Brad "Allan Mitchell" wrote: If you want ultimate flexibility over what happens then call the package from central package using the DTS object model. You can then easily read/write between the twn-n packages. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Brad" <Brad (AT) discussions (DOT) microsoft.com> wrote in message news:6C7EBF46-B29D-4446-96AD-5AF699FAE43F (AT) microsoft (DOT) com... Hello. I have a large daily interface that I decided to break down into multiple packages for ease of understanding. There's one package for each system I extract from. Is there a way to have a package scheduled in the database return a value (true or false for success) to the calling package? I'm looking for a 'native' way to return variables from the executing package to the calling package similar to how the calling package can pass parameters to the executing package. I'd rather not write scripts that read text files for the purposes of returning that value if at all possible. It just seems like there should be a way to do this natively. Thanks for any help! -Brad |
#5
| |||
| |||
|
|
How about something similar to this (from SQLDTS.com) Execute a package from a package (http://www.sqldts.com/default.aspx?215) -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Brad" <Brad (AT) discussions (DOT) microsoft.com> wrote in message news:52E73C15-50FA-43F9-8E3C-999E660118A0 (AT) microsoft (DOT) com... Thank you Allan, that makes perfect sense. So now I just need to find out how to execute a package from an ActiveX script task. I haven't had a need to use the dts com yet. Thanks again. -Brad "Allan Mitchell" wrote: If you want ultimate flexibility over what happens then call the package from central package using the DTS object model. You can then easily read/write between the twn-n packages. -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Brad" <Brad (AT) discussions (DOT) microsoft.com> wrote in message news:6C7EBF46-B29D-4446-96AD-5AF699FAE43F (AT) microsoft (DOT) com... Hello. I have a large daily interface that I decided to break down into multiple packages for ease of understanding. There's one package for each system I extract from. Is there a way to have a package scheduled in the database return a value (true or false for success) to the calling package? I'm looking for a 'native' way to return variables from the executing package to the calling package similar to how the calling package can pass parameters to the executing package. I'd rather not write scripts that read text files for the purposes of returning that value if at all possible. It just seems like there should be a way to do this natively. Thanks for any help! -Brad |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.