I am extracting data from DB2 into SQL Server 2005 using IBM OLEDB provider for DB2. Source table have only 2 columns both are decimal in type. It has only one row for testing. While extracting data using SSIS I am getting following message
SSIS package “Package1.dtsx” starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0×40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0×40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. SSIS package “Package1.dtsx” finished: Canceled.
The program ‘[3796] Package1.dtsx: DTS’ has exited with code 0 (0×0).