Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rpatel18
Starting Member
9 Posts |
 Posted - 2007-07-02 : 13:40:04
|
| I have 4 tasks for importing tables into a database in DTS, but I want to know how I can make all those work parrallel. They just import tables, but right now its doing it one by one. How do I set the workflow so that all 4 happen at the same time. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-02 : 13:44:05
|
| Do not add workflow between any of them and they will launch at the same time.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rpatel18
Starting Member
9 Posts |
Posted - 2007-07-02 : 13:52:33
|
 thats how it looks like right now but keeps on doing them individually |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-02 : 14:06:14
|
| Your image is not visible to us.Here's what the view source looks like for this page:<img src="F:\RPATEL\My Pictures\untitled2.bmp" border="0">We can't see your F drive.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rpatel18
Starting Member
9 Posts |
Posted - 2007-07-02 : 14:06:53
|
| fixed |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 14:33:31
|
| How many cpus does the server have? You can create 4 packages and let them run at same time. |
|
|
|
rpatel18
Starting Member
9 Posts |
Posted - 2007-07-02 : 14:56:51
|
| can I just split those up in 4 packages without having to make new ones? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-03 : 12:59:05
|
| Not as I know of. |
|
|
|
|
|
|
making tasks run parrallel