Package cancelled with no error message..
Im running a package that uses an OLE datasource, a fuzzy lookup, a data conversion and an excel destination. When I run it,the OLE datasource and fuzzy lookup turn yellow and above the fuzzy lookup box it says 9,777 rows. The output box says this: SSIS package "Package1.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. SSIS package "Package1.dtsx" finished: Canceled. There are no errors or warnings in the Progress tab. Does anyone know why the package might have cancelled with no errors? Any idea how I might get an idea of whats wrong? Cheers, Zoe
May 30th, 2012 8:10am

Hi, Could it be that the lookup is caching many more rows than it shows. Have a look at this thread : http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/3460a0a6-482b-49d1-89e9-826314437d09 Hope it helps. Cheers Rgis
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 8:28am

Thanks for your help Regis, Turns out that the same problem doesnt occur when I use SSIS 2012. Cheers!
May 31st, 2012 6:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics