When i ran SSIS 2005 package from BIDS tool Excel 2007 (.xlsx) created successfully and we able to open file without any errors.
When i ran SSIS 2005 package from SQL Job (SQL 2005) Excel 2007 (.xlsx) created successfully,
but file not able to open its giving below error
"excel cannot open the file because the file format is not valid 2007"
can anyone suggest what was the issue how to resolve it ?