It is possible the packages are stored in SQL Server.

Does the package source for the job step say "SQL Server" ?

Try connecting to the Integration Services instance in SSMS and...

This seems similar to a known bug http://connect.microsoft.com/SQLServer/feedback/details/425661 that has not yet been fixed (I think - at least not in SP1, SP2 or SP3), but that was on Win...

I have done this, but can't access the source code right now.

From memory, you need to use windows authentication on your web site and then impersonate the end user in...

So, you just have one table on the report? nothing else?

Try this...

SET @HTML='<table id="table2" width="100%">'+

'<tr class="MyHeader" bgcolor="#e2e2e2">'+

'<th align="Left">Type</th>'+

'<th align="Left">Gate</th>'+

'<th align="Left">Task Name</th>'+

'<th align="Left">Task Type</th>'+

'<th align="Left">Project Name</th>'+

'<th align="Left">Project Manager</th>'+

'<th align="Left">Created Date</th>'+

'</tr>'+

CAST((

SELECTtd='ProjectName','',

=Url,

=TaskName,'',

='Test','',

td=Gate,'',

td=TaskType,'',

td=ProjectName,'',

td=[Project Mngr],'',

td=convert(char,ProjectStartDate,6)

FROM ...

Can we see an Actual execution plan as well?

Have you rebuilt the indexes since the upgrade?

Is this query parameterised in a stored proc?

What is the output from SET STATISTICS TIME...

Hi Mark,

That looks like the right style sheet...

Here is one I just did to test it works:

And the bit of the css that I changed...

...Can you post an execution plan?

One change seems to be to remove the Entity table - it is not being used.

...and get rid of the "TOP 1" from the EXISTS...

...and be more selective about the...

Please also consider this - it is a lot faster and neater IMHO...

SELECT '#C6CFFF' AS [@bgcolor],

s.name As ,

...

You have duplicate numbers in the "Dnums" table, so you need a distinct, like this:

select *

from #cnums cnums

where (

select count(distinct dnums.D)

from #dnums dnums

where dnums.D in (cnums.D1,cnums.D2,cnums.D3,cnums.D4,cnums.D5,cnums.D6,cnums.D7)

) = SIGN(ISNULL(D1,0))+SIGN(ISNULL(D2,0))+SIGN(ISNULL(D3,0))+SIGN(ISNULL(D4,0))+SIGN(ISNULL(D5,0))+SIGN(ISNULL(D6,0))+SIGN(ISNULL(D7,0))

you have a comma in 90,78 instead if a decimal point.!

You...

VGish (10/5/2012)

---

Thank you, I liked the mister.magoo's idea, as it is faster. But, I didn't realize that, some of the vlaues in the #dnums are float like 11.20, 34.55...

Thanks Chris, that's handy to know 😀