Let me preface this by saying I'm brand-new to SSIS development.
I'm using 64-bit SSIS 2008 and I'm trying to read an Excel spreadsheet using OLE DB. I've already run into and corrected the Run64BitRuntime problem. Now when I invoke the Package it cancels immediately with the following output:
SSIS package "Lesson1X.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
SSIS package "Lesson1X.dtsx" finished: Canceled.
The program ' Lesson1X.dtsx: DTS' has exited with code 0 (0x0).
When I edit the Excel Source component itself there are no errors and I am able to Preview the results successfully. If I use Table or View to access the file, the package runs successfully.
Any suggestions will be greatly appreciated.
View Complete Post