@Baliram.

thanks for u r suggestion...But the SP that i execute is dynamic..

So before executing we really dont know wht would be the number of columns..

so temp table cannot be created..prior...

hm..ok ..i will try for some workaround.

Thanks anywyz..

Dear frnd,any luck with this?

ok, any idea abt this?

"if i cant get the expected number of columns for an SP,with out actually running it"

i explained this in previous post..if u hav missed it..

can someone tell me if i cant get the expected number of columns for an SP,with out actually running it..like the sql server internally compiles and tells us wht is...

Thanks Dear frnd..ii tried it.but get the below error

Server: Msg 7357, Level 16, State 1, Line 2

Could not process object 'SET FMTONLY OFF exec dbo.spPAWTest2 9661,'N''. The OLE DB provider...

wen i run the printed statement

select * into ##tmptest FROM OPENROWSET("SQLOLEDB","Server";"sa";"PWD","SPTest 9661,'N'") AS a

i still get

Server: Msg 208, Level 16, State 1, Line 2

Invalid object name '#tmp'.

#tmp is...

i am using sql server 2000...so not sure i can use table variable..

Hello,my SP works fine if it doesnt have a temp table...Only problem is i cant pass a procedure to OPENROWSET command which has a temp table..

meanwhile,i am trying if i...

When i print @string this is wht i see

select * into ##tmptesting FROM OPENROWSET("SQLOLEDB","ServerName";"UID";"PWD","sptest1 10,'Y'") AS a

And the error i get is,

Invalid object name '#tmpFirst'. Where #tmpFirst' is the temp...

well,we are not using a job as such..

All i am trying to do is,get the result set of an SP and put into a temp table for further processing.

In this...

i used this for the above problm

declare @string varchar(1000)

set @string = '' 

set @string = ' select...

Thanks noggin..Have a nice time.

Hello noggin,

My package works fine with sheduled job.

I removed the mail task that i had in the package and changed the location of the file.

But still help me how to...

Hello noggin,

This is the error loged in the package log.

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon...