Anyone have an answer to this?

Anyone have an answer to this?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Anyone have an answer to what?
(Hint: if you use a threaded newsreader, instead of a web-based interface,
and keep the subject the same as it was before, you'll have better luck
tracking threads and following up.)
http://www.aspfaq.com/
(Reverse address to reply.)
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OWNxJhmSEHA.2408@.tk2msftngp13.phx.gbl...
> Anyone have an answer to this?
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
sql

Anyone have an answer to this?

Anyone have an answer to this?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Anyone have an answer to what?
(Hint: if you use a threaded newsreader, instead of a web-based interface,
and keep the subject the same as it was before, you'll have better luck
tracking threads and following up.)
http://www.aspfaq.com/
(Reverse address to reply.)
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OWNxJhmSEHA.2408@.tk2msftngp13.phx.gbl...
> Anyone have an answer to this?
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Anyone have an answer to this?

Anyone have an answer to this?
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Anyone have an answer to what?
(Hint: if you use a threaded newsreader, instead of a web-based interface,
and keep the subject the same as it was before, you'll have better luck
tracking threads and following up.)
--
http://www.aspfaq.com/
(Reverse address to reply.)
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OWNxJhmSEHA.2408@.tk2msftngp13.phx.gbl...
> Anyone have an answer to this?
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Any way to call a Package from a Script Component?

Just wondering if it's possible to call a package from within a script component. I'd think so, but not quite sure how to.

Thanks,

Jeff Tolman
E&M Electric

Do you mean you want to call a package for each input row?

There is no built-in support for this, but you can execute package using DTEXEC.EXE utility. Use System.Diagnostics.Process class to start the process.|||

Yes, after a row is processed I'd like to run another package. The DTEXEC.EXE utility probably would not work since it would be run in another thread space and there probably would be no way to monitor when that process completed.

The SSIS Script component (VSA) editor doesn't seem to make it easy to reuse pieces of code between packages, otherwise I wouldn't need to call a package. I read in the Help files that if you need to use code across packages then it would best to create a user component, but unfortunately I don't have the time to learn how to do that.

Thanks for your help Michael.

Jeff

|||

Check out sample @. http://mystutter.blogspot.com/2006/03/ssis-2005-returning-values-to-calling.html

The author calls another DTSX package from the script task component.

Thanks,
Loonysan