March 18, 2008 at 8:20 am
i just want to know how can i do parallel execution or parallel processing in ssis...i am importinf millions of rows from flat file to database so i jus want to use parallel processin so can i know the settings and tasks which i should use i have got 3 servers so how can i do that ...
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
March 18, 2008 at 5:37 pm
Set up your data flow tasks (or multiple source/destination combinations therein) without any precedence constraints so that the beginning of one task is not dependent on the completion of another. Assuming your isolation level is set to allow it, this will allow you to run several processes in parallel.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply