Viewing 15 posts - 646 through 660 (of 3,232 total)
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...
February 19, 2010 at 2:13 pm
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...
February 19, 2010 at 1:38 pm
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.
February 19, 2010 at 1:34 pm
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?
February 19, 2010 at 1:30 pm
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...
February 17, 2010 at 11:03 pm
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...
February 17, 2010 at 12:46 pm
CirquedeSQLeil (2/12/2010)
VP (unexpected)
Is there a congrats in order?
February 12, 2010 at 9:42 am
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...
February 10, 2010 at 4:05 pm
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...
February 10, 2010 at 3:10 pm
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...
February 10, 2010 at 2:40 pm
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...
February 10, 2010 at 1:05 pm
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...
February 9, 2010 at 4:55 pm
Viewing 15 posts - 646 through 660 (of 3,232 total)