Well in a data-flow you could use a OLE DB Command to write items into the queue but I don't believe you could do a bulk insert.

You could also use...

You can query the WMI class Win32_ComputerSystem and look at Manufacturer and Model.

This works against a Win 2008R2 and Win 2000. Which would mean that everything in between also...

I've run into this as well, I combined the small flows into a single one and ran that in parallel with some others that ran much longer. This gave...

PaulB-TheOneAndOnly (1/23/2012)

---

Dev (12/21/2011)

---

PaulB-TheOneAndOnly (12/21/2011)

---

Elliott Whitlow (12/20/2011)

---

Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they must be...

I am more than a little unsure about the methodology you are employing in your package but it sounds like it is nearly impossible to maintain.

As part of your initial...

You might look at:

http://sqlblog.com/blogs/peter_debetta/archive/2006/07/13/Using-XML-Data-Type-Methods-to-query-SSIS-Packages.aspx

This is where I started from. Word of warning, it aint pretty.. but it seems to work.

CEWII

First, I am fundamentally against trying to make SSIS packages interactive, this is not what the technology is for and requires installation of software on individual machines that may incur...

I have that happen all the time on hot topics..

CEWII

Is the process known? What I mean is that if Phase 1 returns X result you will ALWAYS go Branch A, if it returns Y then you will always...

What kind of selections?

Really SSIS is not designed for user interaction. You would need to know the choice BEFORE the package was started, if that would be ok then...

I don't believe this can be done. I actually think the DLL that contains the underlying component is what controls this.

CEWII

(angels heralding Alleluia)

Well it is good the mystery is solved because we were out of ideas..

CEWII

SSIS is not meant to be interactive. There is no forms builder. It is meant to be run on a server with no interaction from a user. ...

Yes, 2000 supports default parameters. I'm almost 100% sure that 6.0, 6.5, and 7 do as well..

CEWII

Yep, thats it.. Glad they added it.. It was "unpleasant" to have to do that in SQL 2005..

CEWII