I have created a simple SSIS package which will create a .csv file and then it gets pasted to a ftp . The package executes successfully but when I tried to schedule sql job to run this package, it throws up an error
SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "/X86" is not valid. The command line parameters are invalid. The step failed.
In the job execution option I have set the option to use 32 bit runtime and also in SSIS i have set the properties to False for Run64BitRuntime
Any help to resolve this would be really appreciated.
Thanks in advance