you can get around this by setting FMTONLY on if you are executing the stored proc as sql (not ADO command). the ssis execute sql should look like:

set fmtonly on

exec...

I have this problem from ALL clients.

yes, and I can login via EM, with the sa account and a local admin account (trusted) .. but get the same problem results. QA - no problem.

you can use the OA system stored procs to access a registered dll, just like you would via vb or vbscript

join to itself as a subquery or join

select * from sales s1

join (

select emp_id, max(sales_date) as sales_date

from sales s2

group by emp_id

) s2 on s1.emp_id = s2.emp_id and s1.sales_date = s2.sales_date

the vbscript code would look something like this:

SQlServer=WScript.Arguments(0)

Filename=WScript.Arguments(1)

const TrustedConnection = 256

dim version1

Set oPackage1 = CreateObject("DTS.Package2")

oPackage1.LoadFromStorageFile Filename,"","","",""

oPackage1.SaveToSQLServer SQlServer, , , TrustedConnection...

Can you please post the sql for the stored proc.

You need to use the COM object either via the OA extended stored procs, a script, .NET, etc.

it was only 1 row. the total table size is 4.4M. It now returns sub second.

It was for 1 row, at most it would have returned 8 rows. The statistics could have been out of date since we just loaded the data (bulk). The Index...

now, the query is using they index. I don't get it. and the response is sub second. you calc on the amount of data is way off for just one...

Tooo many late nights .. I missed that I had added a computed column, although it wasn't showing up in the script or visual from Object Browser since I hadn't...

use a correleated subquery

for instance:

id | grouping

select grouping, (select count (*) from table b where b.id < a.id and a.grouping = b.grouping)

if the conditional is within the data of tables 2 and 3, and are mutually exclusive, then a left outer join with the appropriate where clause will do the trick...

try calculating the first day of the month following and the subtract 1 minute, you'll have the last day of the month irregardless if it is 30, 31 , 29,...