Here's a solution where you can use a Tally, or numbers, table to explode out the MaxInstalls value to get the total available slots for an installer and then join...

Also, a description of the business reasons for this package would help. Are all of these tables created just to manage your SSIS process or are these tables used...

Have you configured the XSD Location to point to a valid XML Schema document? This is where SSIS will read the column for your XML data sets.

Can you show us some sample data for those 2 tables and, more importantly, an example of the result set you want to see returned?

Waiting.....

red tape

I'm with Paul here. I'm not quite sure what you want. Wesley has been kind enough to post your sample data in a readily usable form, but it...

Well, first off, the code you've posted won't pass the compiler as it contains invalid SQL statements so it can't be producing what you've shown.

This seems like a...

Well, congrats then!

Is there a congrats in order?

I would have to disagree with the bulk-receive approach anyways. His activation procedure is using the eternal WHILE loop method as well. This will not allow SB to...

First off, you don't need to use table variables to make this work. Second, it's a bit difficult to help you on this without some sample data and an...

I may have an additional insight for you here. I've developed a number of solutions now using Service Broker and I ran across a similar problem the first time...

That's one way to go. An alternate solution would be to have your ExecuteSQL task call a stored procedure. You can then use the SP to return your...

Well, let's say you have a database with 3 tables: TableA, TableB, and TableC. Tables A&B contain transactional data and changes quite frequently so you want to backup these...