Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickStan
Starting Member
36 Posts |
 Posted - 2009-11-30 : 10:38:04
|
| I have an SSIS package that errors when I try to run it in Visual Studio, but when it runs as a job it completes with success.I have setup (in the SSIS job properties under steps) to quit job reporting failure when failure occurs.Are there any other properties I need to set?I have a for container and one of the steps is to try to download a feed.The feed is available, but has no records in it.The application (via execute process task) that I am using to import the records is returning error code 18 - success is 0.For some reason the job is not seeing this error.Any help appreciated.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-30 : 11:06:18
|
| how are you calling ssis in job? using command line arguments? |
 |
|
|
NickStan
Starting Member
36 Posts |
Posted - 2009-11-30 : 12:00:33
|
| Once I had the job setup, I scheduled it via jobs -> New jobs.I did not specifically set any command line arguments for the SSIS package.If I check the properties of the job and I look under General -> command line, I have 'restore the original options' checked. |
|
|
|
|
|
|
SSIS package does not fail (when it should)