hi friends,

First of all I'm sorry as I'm recalling this old post.

I came accros the same problem 'Using Stored Procedure with temp table in SSIS' , and accidently I saw...

Hi friends,

I just got it , if we give the below two lines at the beginning of the sp it works!!!!

SET FMTONLY OFF

SET NOCOUNT ON

ie

CREATE PROCEDURE SP_NAME

AS

BEGIN

(@P1 INT, @P2...

Hi I tried this,

It was working when I gave the below lines to SQL command data accessing mode.

SET NOCOUNT ON

Exec sp_name 1

here 1 the the value. But when I...

Thanks,

So you mean to say, no matter how many temp table I use inside the Sp? The dummy need to be ceated only for the final result?

Regards,

MC

You just need to execute sp_help tablename , it will result different data sets, the last data set gives you the details of ForeignKey reference.

Note : If sp_help is configured...

hi use the below query.

WITH DUPE AS

(

SELECT BOOKNAME,PRICE,AUTHOR,ROW_NUMBER() OVER(ORDER BY BOOKNAME,PRICE,AUTHOR ) AS ROWNUMBER

FROM TABLENMAE )

DELETE FROM DUPE

WHERE ROWNUMBER NOT...

Hi friends,

Thanks for all the reply, I was a little bit busy so was not able to reply.

In my sp ,I'm using temp tables many times, it is not for...

hi thanks,

With table variable it worked..!!!

so shall I conclude that with #table it wont work...?

Regards,

MC

hi friends,

I fount the reason for this unexpected thing!!! In side SP I have used #table and the final result I'm selecting from #table!!!

I don't want to create...

Thanks,

No ,there is no nested Sp, based on the parameters it is doing some calculations and inserts the result into one #table, finally it selects the columns from the #table.

I'm...

Hi ,

One other option is , select the Dataset--> Click the edit option-->Choose Filter tab --> Select required field in Expression column--> select != in operator --> Give value as...

Hi Thanks for reply,

In my case the situation is I need to make use of a filed from the second dataset, in the expresion of a details field in a...

Hi if I understood your problem correctly, it can be done by LEFT JOIN as bellow. Is my understanding is wrong please let me know more details.

--CREATE TABLE PERSONEL

--(

--NAME VARCHAR(30)

--)

--GO

--CREATE...

Hi thanks for reply,

But unfortunately, I didn't do any of the things you mentioned. the issue came at a sudden.

Regards,

MC

Hi Thanks for reply....

Im not sure whether you got the complete understanding of the issue.....

If you tried the issue I mentioned you might end up saying that "Visibility and...