To get some decent answers, it might help if you post table DDLs, sample data and desired output.

Your caps lock seems to be broken.

On topic: you can query the SSRS webservice to get the report in HTML format. I'm no Cold Fusion expert, so it's up to...

J39L4753 (10/3/2013)

---

Sorry forgot to add that A8, A9 E8, E9, L8 are cell rows within Excel

Column A = PersonID

Column E = DateOfAppt

Column L = is the column that I will...

An alternative might be to use the Import/Export wizard to copy the tables from one server to the other.

To give a little more information about dwain's answer (he is totally correct):

you are doing an integer division before you cast it to a decimal.

This means the result is rounded...

If you know Java well, C# is the obvious choice.

You can do the same things in a script task/components with C# or Visual Basic, so it all boils down to...

SELECT

CASE WHEN (A9 = A8) AND (L8 = 'MoreThan1')

THEN 'MoreThan1'

ELSE CASE WHEN (A9 = A8)

THEN CASE WHEN (E9 = E8)

THEN 'OneStop'

ELSE 'MoreThan1'

END

ELSE 'OneStop'

END

END

FROM myTable

You should be able to just kill it, transactions should rollback.

If you want to know what is going on, save the SSIS package instead of running it and inspect it's...

Better brush...

Jeff Moden (10/2/2013)

---

pawana.paul (10/2/2013)

---

Thanks Jeff.

I tried to find ACE Drivers details but not able to find much. Please let me know the web links where I can gain more...

Nice one, thanks.

Just add it as an attachment to a post.

So if I have...

There's no clear way of telling.

You'd have to ask the developer who created them.

If I create a bunch of stored procedures, some of them calling others, how would you know...

There's no "first" report. When a user clicks on a report, SSRS runs the report.

You can have master reports though which use other reports as subreports or use other reports...