[?] DataSets execution order

Hello,
How to set the fixed order of DataSets execution? For example, I need
DataSet2 to be started only when DataSet1 is finished.
Thanks,
Lucy.If you mark the data source to "Use single transaction", the queries will
have to execute in series (unless you happen to have a custom data provider
that supports transactions spanning multiple connections, which would allow
us to execute them in parallel... but we didn't ship any such data
providers)
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Lusy Crown" <evesq@.uk2.net> wrote in message
news:OybWKscaEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hello,
> How to set the fixed order of DataSets execution? For example, I need
> DataSet2 to be started only when DataSet1 is finished.
> Thanks,
> Lucy.
>|||Yes I see if I check "Use single transaction", the queries runs
sequentially. But is the way to be sure that query from DataSet1 will start
prior to query from DataSet2?
Thanks,
Lucy
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:uwyZ2DdaEHA.2632@.TK2MSFTNGP10.phx.gbl...
> If you mark the data source to "Use single transaction", the queries will
> have to execute in series (unless you happen to have a custom data
provider
> that supports transactions spanning multiple connections, which would
allow
> us to execute them in parallel... but we didn't ship any such data
> providers)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Lusy Crown" <evesq@.uk2.net> wrote in message
> news:OybWKscaEHA.2972@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > How to set the fixed order of DataSets execution? For example, I need
> > DataSet2 to be started only when DataSet1 is finished.
> >
> > Thanks,
> > Lucy.
> >
> >
>|||When running sequentially, they'll execute in the order they appear in the
RDL file.
(Unfortunately, we don't have anything in the design tool to let you reorder
them. If you need them in a different order, you'll have to hand-edit the
RDL to rearrange them).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Lusy Crown" <evesq@.uk2.net> wrote in message
news:OsB0AKdaEHA.3596@.tk2msftngp13.phx.gbl...
> Yes I see if I check "Use single transaction", the queries runs
> sequentially. But is the way to be sure that query from DataSet1 will
start
> prior to query from DataSet2?
> Thanks,
> Lucy
>
> "Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
> news:uwyZ2DdaEHA.2632@.TK2MSFTNGP10.phx.gbl...
> > If you mark the data source to "Use single transaction", the queries
will
> > have to execute in series (unless you happen to have a custom data
> provider
> > that supports transactions spanning multiple connections, which would
> allow
> > us to execute them in parallel... but we didn't ship any such data
> > providers)
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "Lusy Crown" <evesq@.uk2.net> wrote in message
> > news:OybWKscaEHA.2972@.TK2MSFTNGP12.phx.gbl...
> > > Hello,
> > >
> > > How to set the fixed order of DataSets execution? For example, I need
> > > DataSet2 to be started only when DataSet1 is finished.
> > >
> > > Thanks,
> > > Lucy.
> > >
> > >
> >
> >
>