Saturday, November 22, 2008

SSIS 2008 : New Features

(1)Control Flow
a)Script Task(Can write C#.net code)

(2)Data Flow
a)Data Profiling
b)Lookup Transformation has new Cache Types(Full,Partial,nocache).We can also make sure misses are ignored and database is not queried in future occurrences.

(3)Connection Managers
a)New Cache Connection Manager

(4)Execution
DUMP feature
Thread pooling improvements

No comments: