Hi , We have following options for OLEDB destination 1: FastLoadKeepIdentity 2: FastLoadKeepNulls 3: FastLoadOptions(TABLOCK, CHECK_CONSTRAINTS, ROWS_PER_BATCH). I wanted to know, Is there any way in which the oledb driver can understand that these properties are set for oledb destination in SSIS?And is there anything that oledb driver should implement on its side to support these properties. Thanks, Tejaswini.

#1: these propertries there are to set the processing options, yes, OLEDB exposes them, they are so if not set then used with default settings. So in short, the answer is yes, but I think you have misunderstod something. #2: Like I said, these are the options supported by the OLEDB interface, they exposed to a SSIS developr ready to be used.Arthur My Blog

Hi Tejaswini, Please refer to the similar thread: http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/76c1382e-60b0-4114-9725-6ddb44a98850 Thanks, Eileen

Hi Arthur, Thanks for your reply. Actually I am creating the new oledb driver for my database. The three properties SSPROP_FASTLOADKEEPIDENTITY, SSPROP_FASTLOADKEEPNULLS, SSPROP_FASTLOADOPTIONS of SQL servers oledb driver are corresponding to the FastLoadKeepIdentity, FastLoadKeepNulls, FastLoadOptions properties of OLEDB destination respectively. Are there any properties similar to SQL servers oledb provider available for custom oledb provider also? Or is it the case that the OLEDB destination properties(FastLoadKeepIdentity, FastLoadKeepNulls, FastLoadOptions) can only implemented by SQL servers oledb provider? Thanks, Tejaswini.