Sorry for the repeated posts.

If that job is running the ssis package. How to start the process. Do we need to create that ssis package under the new folder?...

Thanks LNNR

Any precautions we may have to follow?

Any constraints we may face in this process?

Thanks LNNR

Any precautions we may have to follow?

Any constraints we may face in this process?

I am assuming that linked server problem. When I test it is showing that Test connection successful but in the production the linked server created using the security option...

No errors in visual studio but from report manager only.

In visual studio, I am getting the preview but when I upload the same rdl to the report manager, it is showing that an error has occured during report processing....

Yes. Through linked server

I go and check D:\MSSQL\MSRS11.MSSQLSERVER\Reportingservices\Logfiles

In that logfile, I can see

appdomainmanger!Defai;tdomain!..::e Error while performing memory shrink: system out of memory exception: Exception of Type, 'system.outofmemoryexception;, was thrown

From the below query the values of temp db files are 15217MB, 56617MB. Autogrowth is on & growth value 10

SELECT

name AS FileName,

...

Hi,

Figureout the cause of error

select temp.id, temp.username,temp.Oldaccount_status,temp.Newaccount_status,eu.id, eu.first_name, eu.last_name, eu.title, eu.account_status, eu.email, eu.username, o.account_number, o.name

from @UserStatus temp

join Tableuser eu

on eu.id=temp.id

join organisation o

on o.id=eu.id

where username=@username

Here I need to remove...

Now I changed

update Tableuser

set account_status = 'Enrolled'

output inserted.id, inserted.username,deleted.account_status,inserted.account_status

into @UserStatus

where username=@username ;

instead of

update Tableuser

set account_status = 'Enrolled'

where username=@username

output inserted.id, inserted.username,deleted.account_status,inserted.account_status

into @UserStatus

Now it is showing...

Hi,

I tested in the visual studio. It is working fine. I can seee the preview tab and it is showing the report but when I uploaded into the report manager...

There is no page breaks for this report.

Hi,

Here how to find the removed tablix member is using in other tablix expressions

The text file has duplicate rows.

After use the groupby clause, Merge statement works perfectly fine.

Thank you