Has anyone else had this problem?
I am using 'OLE DB Destination' task in a data flow. When I select 'Table or view - fast load', check 'Table lock' and 'Check constraints' and run the flow, I get only one row inserted. The data flow edge shows hundreds of thousands of rows flowing to destination and the task completes (turns green).
The problem goes away if I uncheck bulk load (e.g., select 'Table or view').
Is fast load using bulk insert or some internal code?
?
That is weird. Have you tried to set a value for 'Maximux insert commit size'?
As far as I know SSIS uses bulk inserts when fast load is selected.
Use SQL Server profiler to see the databse activity while the package is being run and insepect the results of the progress tab during the debug session...
Other than that; no idea
Rafael Salas
No comments:
Post a Comment