Hi,
I am running into a strange behavior when I try to test a simple package that contains a Data Flow Task with an OLE DB Source and OLE DB Destination. I can preview the records in the Data Source but when I run the package in the designer the Data
Viewer I attached shows no data coming out of the data source. I am not using a package config file therefore nothing changes at runtime. I am using two package connection managers to connect to the source and destination. The package does complete successfully
but data is never copied:
SSIS package "TestPackage.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Data Flow Task, OLE DB Destination [118]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, OLE DB Destination [118]: The final commit for the data insertion has ended.
Information: 0x40043008 at Data Flow T
View Complete Post