Hi there. Im trying to input some data from SQL Server to excel, but, everytime i execute my package, i get the error: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Excel Destination" (79) failed with error code 0xC0202009 while processing input "Excel Destination Input" (90). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. My conection string is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Packages\LollaPalooza_20120106.xls;Extended Properties="Excel 8.0;HDR=NO;IMEX=1"; Fabrizzio A. Caputo MCT Certificaes: Oracle OCA 11g MCITP SQL Server 2008 Implementation and Maintenance MCITP SQL Server 2008 Developer Blog Pessoal: www.fabrizziocaputo.wordpress.com Blog Empresa: www.tripletech.com.br/blog Twitter: @FabrizzioCaputo Email: fabrizzio.antoniaci@gmail.com

show a screen shot if you canSincerely SH -- MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Hi HI Fabrizzio Caputo, Are you running Integration Services Packages on 64 bit (64-bit) Computers? Some Integration Services features are available only in 32-bit versions, or have limitations on 64-bit computers. For example, the Microsoft OLE DB Provider for Jet, which connects to Excel spreadsheets, is not available in a 64-bit version. If in this case, please set SSIS project property Run64BitRuntime to False. This is a instruction to load 32-bit runtime environment rather than 64-bit, and the packages would run without doing any plumbing work. The property can be found under SSIS Project Property Pages -> Configuration Properties -> Debugging. For more details about 64 bit Considerations for Integration Services, please see: http://blogs.msdn.com/b/amitlale/archive/2007/12/11/ssis-64-bit-setting.aspx http://msdn.microsoft.com/en-us/library/ms141766.aspx Thanks, Eileen TechNet Subscriber Support If you areTechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.