SSIS와 관련된 SS2005 SP1 변경 사항

SQL 2005 서비스 팩1이 발표되면서 많은 부분들이 개선되었습니다. 이들 중, SSIS와 관련된 변경 사항에 대한 것입니다.

 

• Usability of the Import/Export Wizard has been improved in multiple-table scenarios.   • The IDtsPipelineEnvironmentService service lets custom data flow components have programmatic access to the parent Data Flow task.   • Interoperability with Analysis Services has been improved. The DataReader source in SSIS supports the System.Object data type by converting columns that have this data type to the DT_NTEXT ssISnoversion data type. To change the data type to a type that is more appropriate for your data, you can add a Data Conversion transformation.   • Performance has been improved for many transformations, such as the Sort transformation.   • Designer usability has been improved. For example, you can now right-click Dataflow and then click Execute Task to execute only the Dataflow task. You do not have to switch to the control flow to execute only the Dataflow task.   • The Expression Builder dialog box now has a public and documented API. This increased access to expression-related objects will benefit task developers because expressions are important to the way that tasks are interrelated.   • We have added a registry-based policy for handling SSIS package signatures as a package is executed. For example, administrators can disable loading of unsigned packages and untrusted packages. Because these settings are in the registry, administrators can propagate these settings in the domain by using Microsoft Windows Group Policy policy settings.   • In the Advanced Editor dialog box, the Flat File source has the new property UseBinaryFormat. This property supports loading packed decimal data into the pipeline for processing by a script or by a custom transformation.   • In the Advanced Editor dialog box, the DataReader source has the new property CommandTimeout. You can use this property to modify the time-out period to allow for long-running operations.   • To create or to modify the property expressions of variables, you can now open the Expression Builder dialog box from the Properties window.   • You can now add annotations to precedence constraints.

 

아직 몇가지는 개선이 안된 점들도 있겠지만, 여러모로 조금 더 좋게 된 것 같습니다..

 

참고하시고, SSIS를 이용하시는 경우 꼭 SP1도 같이 설치하셔서 이용하세요~~^^