Problem with jobs when using Sharepoint List Source

Mar 24, 2010 at 5:13 AM

I have a job that i have used the Sharepoint List Source.

This works on my dev with no issue but when i move it to production which is a 64bit

I get the error below

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
03/24/2010 15:08:29,ImportStoreCommsList,Error,0,myserver,ImportStoreCommsList,(Job outcome),,The job failed.  The Job was invoked by User DOMAIN\user.  The last step to run was step 1 (stImportStoreCommsList).,00:00:01,0,0,,,,0
03/24/2010 15:08:29,ImportStoreCommsList,Error,1,myserver,ImportStoreCommsList,stImportStoreCommsList,,Executed as user: Domain\user. nd returned error code 0xC0048021.  End Error  Error: 2010-03-24 15:08:30.07     Code: 0xC004700C     Source: Data Flow Task DTS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2010-03-24 15:08:30.07     Code: 0xC0024107     Source: Data Flow Task      Description: There were errors during task validation. 

End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  3:08:29 PM  Finished: 3:08:30 PM  Elapsed:  0.219 seconds. 

The package executi failed.  The step failed.,00:00:01,0,0,,,,0

Does the Sharepoint List Source and Destination work on the 64bit?

Any ideas why its failing?
Thanks in Advance