Prev: Multiple SCOPE_IDENTITY
Next: How to check record exists before INSERT multiple records
From: jm27102 on 21 Jun 2010 17:57
I generate SSIS package multiple table data loads, and write a record to a
data generation table. I wish to insert the last data generation date from a
SQL Server into the header (or footer) of an SSRS report.
Does anyone have thoughts on best practice for this ?
Thank you,
From: Uri Dimant on 22 Jun 2010 00:56
Issue SELECT TOP 1 datecolumn FROM tbl ORDER BY datecolumn DESC




"jm27102" <jm27102(a)discussions.microsoft.com> wrote in message
news:29B2B300-655E-42D7-B397-DEEB5FE2525D(a)microsoft.com...
>I generate SSIS package multiple table data loads, and write a record to a
> data generation table. I wish to insert the last data generation date from
> a
> SQL Server into the header (or footer) of an SSRS report.
> Does anyone have thoughts on best practice for this ?
> Thank you,


From: jm27102 on 23 Jun 2010 16:42
Hi Uri,
Thank you for your input.
I understand that aspect of it.
What I am not clear on is creating a secondary data source in the query to
pull data from that table so it can be placed in the header.
The data source needs to be pulled just once, and inserted. Somewhat similar
to a DLookup in MS Access, I presume ?

"Uri Dimant" wrote:

> Issue SELECT TOP 1 datecolumn FROM tbl ORDER BY datecolumn DESC
>
>
>
>
> "jm27102" <jm27102(a)discussions.microsoft.com> wrote in message
> news:29B2B300-655E-42D7-B397-DEEB5FE2525D(a)microsoft.com...
> >I generate SSIS package multiple table data loads, and write a record to a
> > data generation table. I wish to insert the last data generation date from
> > a
> > SQL Server into the header (or footer) of an SSRS report.
> > Does anyone have thoughts on best practice for this ?
> > Thank you,
>
>
> .
>
 | 
Pages: 1
Prev: Multiple SCOPE_IDENTITY
Next: How to check record exists before INSERT multiple records