dbTalk Databases Forums  

Parellel execution of steps.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Parellel execution of steps. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ChrisR
 
Posts: n/a

Default Parellel execution of steps. - 07-10-2006 , 01:05 PM






SQL2K SP4.

Howdy all. I've got a package that imports 7 .txt files into 7 different
tables. When running the package, they say "Started" next to them, but the
amount of rows shown imported next to "Running" only goes up in 1 table at a
time. It is not until Table1 is completely imported that Table2's import
begins. Why? Is there a way to make it *really* start?

TIA, ChrisR

Reply With Quote
  #2  
Old   
CodeDigger
 
Posts: n/a

Default Re: Parellel execution of steps. - 07-10-2006 , 01:55 PM







ChrisR wrote:
Quote:
SQL2K SP4.

Howdy all. I've got a package that imports 7 .txt files into 7 different
tables. When running the package, they say "Started" next to them, but the
amount of rows shown imported next to "Running" only goes up in 1 table at a
time. It is not until Table1 is completely imported that Table2's import
begins. Why? Is there a way to make it *really* start?

TIA, ChrisR
You can set precedence on tasks. Select the workflow, and click
properties. Now select the source step. If you have a DTS Transform
task, you can right click the task, and select Workflow properties. In
the Options tab, select priority.



Reply With Quote
  #3  
Old   
Davide
 
Posts: n/a

Default Re: Parellel execution of steps. - 07-11-2006 , 02:27 AM



Hello ChrisR,

Quote:
SQL2K SP4.

Howdy all. I've got a package that imports 7 .txt files into 7
different tables. When running the package, they say "Started" next to
them, but the amount of rows shown imported next to "Running" only
goes up in 1 table at a time. It is not until Table1 is completely
imported that Table2's import begins. Why? Is there a way to make it
*really* start?

TIA, ChrisR

For each of your step you use to import data verify , using 'Disconnected
edit', that the property ExecuteInMainThred = 0.
Is it ?
Bye




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.