You can parse the HTML file, extract the data and show that in SSRS.

OK. Why does it have to be SSRS?

If you already have the HTML, you can just show the HTML.

Is there a particular reason why it has to be a HTML table?

SSRS can generate regular tables just fine 🙂

Using text boxes, I'm afraid you are stuck with the limitations of SSRS.

SQLLion (3/10/2014)

---

Thanks Koen Verbeeck for your reply and

Thanks SQLCJ for your helpful link.

Now I have changed protection level of package to "EncryptSensitiveWithPassword"

It is working fine on some of my packages,...

Nice article. Very useful for data profiling, amongst other things.

That is fascinating.

Is there also a question?

Hint: read the links How to post forum questions[/url] and Need an answer? No, you need a question.

ps: just to shove you in the...

UserKey is a combination of user and machine related information.

Basically it means sensitive info is decrypted when only you...

Earlier versions of AdventureWorks had some sort of...

aaa121 (3/10/2014)

---

Very interesting response Jeff. I guess a lot of people on here would echo your comments.....and like to have someone who you describe working in their team!

I guess the...

Your point being? Permissions can be given and be taken away...

First step: make sure all those users (except admins of course), can't see any table. None at all.

Then create different database roles, add the correct users to a role and...

twin.devil (3/10/2014)

---

you have two columns in this table

1. [Value] [varchar](max) NULL

2. [File] [varbinary](max) NULL

looks like a contain which holds the...

You say caseno is unique, but in your sample data it certainly is not.

Either use an IDENTITY constraint on the columns, or use the SEQUENCE object (since you posted this...

yuvipoy (3/10/2014)

---

No. I dont wnat this column to...