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