Parallel execution of DTS steps.

Hi,
I have a DTS package that exports 50 database tables from SQL Server to
Oracle.
At this point the DTS package runs steps after each other (serial
execution). Since both servers are extremely powerful, the can handle more
than one concurrent DTS step at a time.
Is there any way to have DTS execute five or six steps in parallel fashion?
Any help would be appreciated,
MaxYes, you can. Basically, tasks run in parallel, unless you have set up
workflows that force them to be run serially. That said, if your source is
the same for all of your data pumps, then the process gets serialized, since
the connection is in use. In that case, create multiple connections, each
of which point to the same server.
For example, if you are pumping from ServerA to ServerB, create, say, 4
ServerA connections - ServrA1, ServerA2, etc. and the same goes for ServerB.
Then, make sure your pumps use the different connections.
HTH
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:eobZWSBWGHA.5044@.TK2MSFTNGP09.phx.gbl...
Hi,
I have a DTS package that exports 50 database tables from SQL Server to
Oracle.
At this point the DTS package runs steps after each other (serial
execution). Since both servers are extremely powerful, the can handle more
than one concurrent DTS step at a time.
Is there any way to have DTS execute five or six steps in parallel fashion?
Any help would be appreciated,
Max|||Then you will have to use a different connection for each datapump.
AMB
"Maxwell2006" wrote:
> Hi,
>
> I have a DTS package that exports 50 database tables from SQL Server to
> Oracle.
> At this point the DTS package runs steps after each other (serial
> execution). Since both servers are extremely powerful, the can handle more
> than one concurrent DTS step at a time.
>
> Is there any way to have DTS execute five or six steps in parallel fashion?
>
> Any help would be appreciated,
> Max
>
>|||http://www.codeproject.com/useritems/DTS__VBNET_.asp

paging

please let me know the steps to set
=Int((RowNumber(Nothing)-1)/2)
expression for pagebreak in rdl file.On Apr 18, 7:34 am, abhi <a...@.discussions.microsoft.com> wrote:
> please let me know the steps to set
> =Int((RowNumber(Nothing)-1)/2)
> expression for pagebreak in rdl file.
Something like this should work.
1. Right click the list/table/matrix control and select 'Properties'
from the drop-down list.
2. Select the 'Edit details group...' button.
3. On the 'General' tab, below 'Group on:' and 'Expression' type in
something similar to the following:
=Ceiling(RowNumber(Nothing)/25)
Where, in this example, 25 is the number of rows per page. Then select
'Page break at end' in the Properties of the list/table/matrix
control. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Page Setup disabled in Report Designer

I'm trying to change the snap-to grid functionality in a SRS 2005 Report Design (within VS 2005). I tried the same steps in the following post, without success. Based on the SRS help, it appears you change Grid Settings by accessing the File > Page Setup dialog, but the Page Setup (along with Print) is disabled.

Maybe these are instructions for Report Builder only? If so, how do you adjust the Grid Settings (to turn off the "snap" functionality) for a SRS Report project in Visual Studio?

Thanks,

Michael

Hello Michael,

From the Report menu, select Report Properties, then in the General tab, uncheck the 'Snap to grid' checkbox.

Hope this helps.

Jarret

|||

Jarret,

That was so easy!

I thought I was seeing all the available properties by right-clicking on the report and selecting 'Properties'.

Great help!

Thanks,
Michael