scheduled export to Excel in SSIS fails -
09-19-2006
, 01:42 PM
I'm trying to schedule a package which exports data from SQL 2005 table
into Excel.
Package consists of the following blocks:
1. Execute SQL Task (drop/create Excel table)
2. Dataflow task (map SQL table into Excel)
Package saved in MSDB with ProtectionLevel="ServerStorage"
Manual execution works fine but scheduled job fails with a message:
"The command line parameters are invalid".
Any idea what should be set differently? |