摘要：
SSIS 包组件的命名规则为了创建一个良好的SSIS项目，需要一套命名规则去命名每个组件，使其意思清晰明了。 下面给出各个组件的推荐前缀如下： SSIS任务命名模板 Task Prefix ForLoopContainer FLC ForeachLoopConatiner FELC SequenceContainer SEQC ActiveXScript AXS AnalysisServicesExecuteDDL ASE AnalysisServicesProcessing ASP BulkInsert BLK DataFlow DFT DataMiningQuery DMQ Execute 阅读全文
摘要：
设计SSIS包的OVAL原则 CreatedasadevelopmentframeworkforSSISpackages,OVALprinciplesofpackagedesignencompassfourfacetsofSSISapplications.Thesedesignconsiderationsincludeidentifyingthe Operations tobeperformed;thedata Volume tobeprocessed(inproduction) ; the Application oftherighttools,tasks,sequence,andflow; 阅读全文
摘要：
ssis性能调优学习笔记 1SSISEngine SSISRuntimeengine和DataPipelineengine（又称为“dataflowtask”）； 2MemoryBufferArchitecture Twofactorsaffectrowsize:Numberofcolumns和Widthofeachcolumn Asarule,selectonlythecolumnsyouneedfromdatasourcesandassignconservationdatatypes wheneverpossible. 3ExecutionTrees Separatememorybuff. 阅读全文