In a case where we are transferring data from a source to destination is slow using the data flow task in SSIS package, the following can be considered.
In the destination task --- oledb destination task , the OLE DB Destination, when connected to SQL Server, enables data to be inserted with bulk insert statements by using Fast Load, click on the olebd destination properties --- click on access mode --- select fast load
No comments:
Post a Comment