Sounds very strange!

Is your source query just a 'standard' SQL command or is it derived from a variable and/or expression? Is the SSIS package running as a SQL Agent job or are you manually executing the package either in Design or Run mode? Is the data time-dependent in any way?

Have you tried running a Profiler trace to check that the target database is being accessed by the query?

Regards

Liam