Thanks All

Hi All.. I need some information regarding SSIS row by row operations. Does SSIS perofrm good by row by row or by data sets (Like Oracle data integrator performs better in data sets rather than row by row.) Can i get some information what SSIS uses and what is the best practise. Thanks

Hi, Do you mean operations like updates? SSIS works with rowsets on memory after read it from sources. There is a component called OLEDB command where you can write TSQL staments like U Update, that works row by row, or Merge that can update a set of rows. always better to use rowsets regarding log operations, index updates, etc.. Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

What do you mean under row by row exactly, any info on what you would like to accomplish? AFAIK, SSIS is the fastest and most complete ETL solution out there, also it is free as long as you have SQL Server license. To 10 SSIS Best Practices: http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx SSIS Overview http://goo.gl/KTQ0UArthur My Blog

In SSIS data flow task, OLE DB Destination is typically used to persist data. OLE DB Destination comes with two options (actually the destination component has more than the following two, but they can still be categorized into the two options). Table or view Table or view - fast load The first option is basically row by row operation in your sense, while the second option is a batch process which uses bcp under the hood. The second option performs a lot faster than the first one. Another typical row by row operation in data flow is OLE DB Command, which is generally not recommended due to its row to row nature. Hope this has addressed your concerns. Daniel Cai | http://danielcai.blogspot.com