How to impose tasks in a DTS Package to run parallel

Last Post 10 Sep 2007 10:15 AM by srinath003. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
srinath003
New Member
New Member

--
07 Sep 2007 07:21 AM
Hi Everybody,

Could anyone can help me out. We have a DTS Package that has around 20 tasks in that.
This DTS package actually extracts data from Teradata database to different text files.
we kept 4 tasks to run in parallel optin in dts package properties. But when we execute this package,
actually only one taks is executing at a time. so how to impose to run tasks to run in parallel.
we have 4 cpu server.
srinath003
New Member
New Member

--
09 Sep 2007 10:07 AM
Thanks for replying back,

No, they are not relying on each other. These tasks have different queries to extract data from Teradata
database and to load into text files on a server. We are using SQL Server for extracting the data from Teradata as a source and text files as destinations.
srinath003
New Member
New Member

--
10 Sep 2007 10:15 AM
Thanks a lot...

Can I have some articles or article links for this?
You are not authorized to post a reply.

Acceptable Use Policy