0

Resolved

The static source in test table XML files doesn't work as expected.

description

Fixed in CL#19643.
 
-- more error output:
Progress: 2009-05-19 16:03:08.29
   Source: __TestTable1_StaticSourceMergeStagingTable 85946f68-b373-441d-a6ee-7e
783b5ab3ab
   Executing query "
-------------------------------------------------...".: 100% complete
End Progress
Error: 2009-05-19 16:03:08.30
   Code: 0xC002F210
   Source: TestTable1_StaticSourceMergeInsertValuesExecuteSql 3f7536f7-9262-4dce
-add1-7e00f6384a08 Execute SQL Task
   Description: Executing the query "
SET IDENTITY_INSERT __TestTable1_StaticSourceMerg..." failed with the following
error: "Table '__TestTable1_StaticSourceMergeStagingTable' does not have the ide
ntity property. Cannot perform SET operation.". Possible failure reasons: Proble
ms with the query, "ResultSet" property not set correctly, parameters not set co
rrectly, or connection not established correctly.
End Error
 
After executing the package, the table structure is created, but lack of data.

comments