Explanation:For using Heap inserts,you may want to drop indexes and rebuild if you are changing a large part of the destination table; you will want to test your inserts both by keeping indexes in place and by dropping all indexes and rebuilding to validate.[/expand] 6. Which of the following error message indicates that the package cannot run in SSIS ?
A. DTS_E_CANTINSERTCOLUMNTYPE
B. DTS_E_CACHELOADEDFROMFILE
C. DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN
D. DTS_E_CONNECTIONREQUIREDFORMETADATA
Answer:A
Explanation:For using Heap inserts,you may want to drop indexes and rebuild if you are changing a large part of the destination table; you will want to test your inserts both by keeping indexes in place and by dropping all indexes and rebuilding to validate.[/expand] 6. Which of the following error message indicates that the package cannot run in SSIS ?
A. DTS_E_CANTINSERTCOLUMNTYPE B. DTS_E_CACHELOADEDFROMFILE C. DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN D. DTS_E_CONNECTIONREQUIREDFORMETADATA
Explanation:Cache Transform transformation is trying to write data to the in-memory cache.[/expand] 7. Which of the following is event logged by the Integration Services Service ?