none
Bulk insert in to a partitioned View?

    Question

  • 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

Answers

  • Hi,

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

    Exporting Data from or Importing Data to a View
    http://msdn2.microsoft.com/en-us/ms187086.aspx

    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
    http://msdn2.microsoft.com/en-us/library/ms188250.aspx

    I hope that helps,

    Bertil

    Wednesday, May 24, 2006 1:59 PM