Is there a system table containing the information if a package has been success

Hi all,
Im not really sure if this is a PHP or and SQL problem but here goes.

Im using MSSQL and have developed a webpage that enables users to run various PACKAGES manually, however I need to display if the package has been successfully run.

Is there a system table that logs package information or is there a PHP function that I can use.

Thanks

P.s I know there are some system tables with the information for jobs but I do not want to create a job for each package.If you say about DTS... then you can find it in msdb database
msdb..sysdtspackagelog... and etc.

Is such a report possible using SSRS 2005 Report Builder?

I have RS 2005 SP1. I have a report model developed and deployed.

I have a scenario and I am not sure if it is possible to create a report for this scenario using the report builder. Let's say I have a customers entity and address entity that is related to the customer's entity as a 1-many relationship. I have the effective date on the address that specifies the date from which the address is effective. A customer will have multiple records in address with the latest effective date as the latest address of the customer.

Suppose, I need to create a report using the report builder to get the list of latest address for customers, how can I do it? I know it can be done using the report designer using a query that uses the group by clause. But can it be done using report builder?

Thanks in advance.

can someone help? Thanks.|||you can just do that in the SQL query in the data set:

Code Snippet

select [customer_name], [Address1],[Address2]
from customer_table ct
inner join (

select customerID,

max(effective_date) as max_date

from address_table

where effective_date < getdate()) as TopAddress

inner join address_table at
on ct.customerID = at.customerID

and at.customerID = TopAddress.CustomerID

and at.effective_date = TopAddress.max_date

This will return all customers with their latest address, excluding any addresses with a future effective date.

There are other ways, eg with embedded sub reports but then, why add the complexity?|||

Thanks for your response.

I know this can be done and I can build a report using this query with the report designer. I wanted to know if a report with the same output can be built using the report builder?

|||My mistake - mixed up the report builder/designer.

Report builder is very very basic compared to the designer and is really meant for end users with some basic technical knowledge.

Expand your report model to add the data functionality you require

Use report builder to determine how to display that data.

Is such a report possible using SSRS 2005 Report Builder?

I have RS 2005 SP1. I have a report model developed and deployed.

I have a scenario and I am not sure if it is possible to create a report for this scenario using the report builder. Let's say I have a customers entity and address entity that is related to the customer's entity as a 1-many relationship. I have the effective date on the address that specifies the date from which the address is effective. A customer will have multiple records in address with the latest effective date as the latest address of the customer.

Suppose, I need to create a report using the report builder to get the list of latest address for customers, how can I do it? I know it can be done using the report designer using a query that uses the group by clause. But can it be done using report builder?

Thanks in advance.

can someone help? Thanks.|||you can just do that in the SQL query in the data set:

Code Snippet

select [customer_name], [Address1],[Address2]
from customer_table ct
inner join (

select customerID,

max(effective_date) as max_date

from address_table

where effective_date < getdate()) as TopAddress

inner join address_table at
on ct.customerID = at.customerID

and at.customerID = TopAddress.CustomerID

and at.effective_date = TopAddress.max_date

This will return all customers with their latest address, excluding any addresses with a future effective date.

There are other ways, eg with embedded sub reports but then, why add the complexity?|||

Thanks for your response.

I know this can be done and I can build a report using this query with the report designer. I wanted to know if a report with the same output can be built using the report builder?

|||My mistake - mixed up the report builder/designer.

Report builder is very very basic compared to the designer and is really meant for end users with some basic technical knowledge.

Expand your report model to add the data functionality you require

Use report builder to determine how to display that data.

Is Reporting Services available in Chinese?

We have a customer in China that is interested in purchasing a solution we
developed using RS and we are wondering if there are there any white-papers
listing issues with running RS against SQL Server (Chinese)?
Any info would be greatly appreciated!Reporting Services is both available in Chinese as well as it works fine
against Chinese databases. There is nothing special you need to do other
than using a font with the required Unicode support.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Alvord" <malvord-NoSpam@.storis.com> wrote in message
news:eXa5j2dxEHA.2196@.TK2MSFTNGP14.phx.gbl...
> We have a customer in China that is interested in purchasing a solution we
> developed using RS and we are wondering if there are there any
> white-papers listing issues with running RS against SQL Server (Chinese)?
> Any info would be greatly appreciated!
>
>