SUBSTRING within Derived Column is ur answer. try using sequence of substrings to achieve this.

" Yes I want to use the RAW file as a source and then update records in the database (tried using TSQL update but not sure about how to get...

u can.

hi, i just restarted SSRS Service..and it worked fine ;)))

try some of the following practice and re-monitor ur package:-

1) dataflow property-> Engine Thread Value-> increase

...

did u get it done?

Did you also try changing the properties of Tablix (from Design) to:

RepeatColumnHeaders/RepeatRowHeaders ->True

where you find <KeepWithGroup>After</KeepWithGroup>

insert the below code with it:

<RepeatOnNewPage>true</RepeatOnNewPage>

<KeepTogether>true</KeepTogether>

and it should work for you.

--VT

You need to go into the .RDL code of your report, in that search for <TablixRowHierarchy> which has all your <TablixMembers>. You need to make sure here that each of...

nop, the user has mentioned that SQL Browser is running under Local Service.

Also try changing SQL Server Browser to 'Local System'

Nothin should be run as your NT Authority log on.

Try it and restart the service and re-deploy.

--VT

Also try changing SQL Server Browser to 'Local System'

Nothin should be run as your NT Authority log on.

Try it and restart the service and re-deploy.

--VT

Also try changing SQL Server Browser to 'Local System'

Nothin should be run as your NT Authority log on.

Try it and restart the service and re-deploy.

--VT

Hi,

Your suggested solution is what I have tried earlier which is very true, and because of that I came to know there are 2 members (only) for this [Big vs...

As I said earlier, I cannot change anything from BIDS/VS as I dont have access, so there is no point of setting visibility prop to 'True' (or sumthin like tht...