Thanks friends.

The scenario is I have stored procedures which are used by SSRS reports and inside the SPs we have so many temp tables.

So when the report runs it...

Ok... Thank you all, for your reply.

Thanks for the reply.

So both of the above reply together answers my question thanks friends.

I would like to clarify one more thing, as the temp table is getting dropped once...

Hi Thanks for the reply.

I agree that the table will be dropped when I close the session, but then the space used also will be released?. And if that is...

Hi,

can you try running the package in BIDS ( Business Intelligence Develeopement Studio) ? When you added the new column to the table you would have kept it as NOT...

Hi Welsh Corgi & Gila Monster Thanks for the reply.

Welsh Corgi,

In your reply you have mentioned that the Functions are not pre-compiled,but in the answer section of the link you...

Hi,

Create a variable , then pass the value (either hard code or get it dynamic ) then do the mapping of that parameter in Execute SQL task.

While declaring the...

Happy to know your issues is solved.

Thanks for the feedback...

Ok..

Do like this , add a report parameter , say Status, with the three available values (Yes,No,NoFilter) as:

Lable = Yes , Value = No

Lable = No , Value = Yes

Lable...

Hi,

Please explain how is your code at present.? Is the code returns data based on the parameter as for example

select * from table

where column_name = @p

So that the @p value...

Hi Dileep,

Thanks a lot.. it worked.. 🙂

Ok.. Thanks.

Thanks Da-zero,

So it is a bug, thanks for your information, and yes while creating the tasks we have to make 32 and 64 separate.

By the way how do we...

Da Zero,

I understood what is happening.

Long back I had a trouble in using Excel Source/destination in SSIS 2008, then as a reply for my post in this forum I have...

Hi,

There is no error ,it turned Yellow and continued as yellow.

There is no output from Fuzzy Look Up and so the destination object didn't executed (didn't even turn to Yellow)

...