I have a ssis package ,inside in a dataflow task iam pulling data out from the OLEDB source and writing to Excel destination i have already created a excel file and pointing to it. It gives an error: Unspecified error. Iam not able to figure it out. Can somebody help me in it.latha

could be data conversion error... can you print the error message... check the input and output column datatypes and use data convert task to convert them to correct data typeshttp://uk.linkedin.com/in/ramjaddu

So the package does not run even once? And please post the entire error. See this video on how to export data to Excel http://www.youtube.com/watch?v=CJI6pPueyzMArthur My Blog

could be data conversion error... can you please print the error message... please check the input and output data types use data convert task to convert them to correct data type http://uk.linkedin.com/in/ramjaddu

There are no errors due to data conversion or some thing like that. When i drag and drop the excel destination and open it i gave the Excel Connection manager to connection field.Select Table or view.Now then pointing to select table it says "Unspecified Error" latha

What version of Excel are you using? What connection provider are you using?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

Is this 32bit or 64bit system ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I am using Excel 2007.latha

I am not sure about version?But its 32 bit i think.latha

I am not sure about version?But its 32 bit i think. latha What OS is the machine running where your package fails? Is it 32bit or 64bit ?SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Its 32 bit. I just now open the package again just deleted the data flow task and again created it from scratch now there is no error. But i need the reason why it was failed yesterday saying "Unspecified Error".Now it working fine.latha

Its 32 bit. I just now open the package again just deleted the data flow task and again created it from scratch now there is no error. But i need the reason why it was failed yesterday saying "Unspecified Error".Now it working fine. latha The stored metadata might have been not in sync with the Excel file, causing the trouble.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/