Bulk insert in to a partitioned View?


  • Greetings once again my SQL friends,

    I am getting the following error when I attempt to complete my data flow task. The destination is a partitioned view but I get the following error message when I run the package :

    Partitioned view 'PRICE_DIM' is not updatable as the target of a bulk operation


    How to solve this problem?


    Wednesday, May 24, 2006 11:24 AM


  • Hi,

    Bulk insert operations are not supported for partitioned views. See for more details:

    Exporting Data from or Importing Data to a View

    You can import Data within a Data Flow Task into a Partitioned View if you use an OLE DB Destination with the Data Access Mode option set to Table or View instead of "Table or View - fastload", which is the default and technically a bulk operation.

    Please be aware that locally partitioned views are supported in SQL Server 2005 only for backward compatibility. See also:

    Scenarios for Using Views

    I hope that helps,


    Wednesday, May 24, 2006 1:59 PM