You could also sort your data at the extraction point. That is substantially faster than the sort transform, since the heavy lifting is done on the SQL server side and...

You would have to create a single package for each table which you wish to operate upon. Because SSIS is metadata driven (meaning that your columns/datatypes cannot change at run...

Can you please post your script code so that we can see what it is you are trying to do? Thanks.

My vote would be for either the Sort Transformation (atrocious!!) or the Partial Cache Lookup on the Advanced properties of the Lookup Transform.

If you write solid code, your script can...

Are you utilizing Sharepoint lists at all? Or are you just needing to be able to publish an HTML document to a general location on Sharepoint? I know that there...

That was exactly what I needed. Thanks, Mark!

Works perfectly!! Thank you, thank you!!

Finally found the answer.

For those interested, I encompassed the two "legend" matrices into a subreport. Then, I included that subreport as part of the details report as a table header....

In order for the image to display when the report is being rendered on the report server, you have to upload the image to the report server itself. Upload an...

There is a reason -- the reason is that the solution that I posted above WORKS, albeit slowly. I tried your solution, and I have performance issues with it as...

Crap -- you're right about not getting the same results. There has to be a way around using ISNULL. That specific piece is causing records to come back 200/minute, which...

After working with MM's query, I was able to get results to come back in 36 seconds. Below is the final SQL that I was able to get working:

--= Dump...

mister.magoo (12/30/2009)

---

For the sake of it, a solution which copes with new "ColumnName" values by using dynamic sql (go ahead - pork chop me or whatever you do :-D)

If you...

This is what I've come up with so far:

declare @count int

declare @groupcount int

declare @NumberofRows int

select @NumberofRows = COUNT(*) from @school

set @count = 1

set @groupcount = 0

while @count <= @NumberofRows

begin

if (select...

I just did a select distinct, and those are all of the columns from the table.