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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Parallel Processing

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-03-25 : 06:12:42
Hi,

I have a huge chunk of file and would like to split the data into 2 logical file and process the data in parallel to the target table.

Is it possible to do it via SSIS so that it can take the advantage of running the process in parallel. You can also assume that the file has a unique identifier to identify the records for simplicity reason as of now.

Thanks in advance
   

- Advertisement -