SSIS package created using Import/Export wizard failing on tmp files.

If we try to create a SSIS package from Import/Export wizard with option “Optimize for many tables” its possible that we may run into error messages like Could not find file ‘C:\Documents and Settings\d108967\Local Settings\Temp\1\tmpD7.tmp’.”. The reason for this is the way this SSIS package work. If you open this package in BIDS you would…

1