January 11, 2010 at 9:38 am
I've setup my SSIS Package to run as a scheduled job in sql server 2005. Ive installed the package as a stored package and created a job and set it to run as a schedule. Im testing it on my local pc and set the job to run today at a specific time. The job kicked off OK and began the first part of the process which was to download a zip file from an ftp server and unzip it. This went Ok until I had to connect to a sql server database. In my config file, I had the wrong server name specified, so the package failed (a good test of my email failure notification)
I changed the server name in the config file and changed the schedule of the job to run 5 mins from the current time. The specified time came and went and the SSIS package didnt run. I checked the history log and could see it had failed and generated an error
Message
Executed as user: PSLW16792\SYSTEM. ...n 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:11:00 Error: 2010-01-11 16:11:02.09 Code: 0xC001F003 Source: OnError Description: Changing the name of a variable failed because it is a system variable. System variables are read-only. End Error Error: 2010-01-11 16:11:02.09 Code: 0xC001F004 Source: OnError Description: Changing the namespace of a variable failed because it is a system variable. System variables are read-only. End Error Error: 2010-01-11 16:11:02.09 Code: 0xC001F002 Source: OnError Description: Changing the property of a variable failed because it is a system variable. System variables are read-only. End Error Error: 2010-01-11 16:11:02.09 Code: 0xC001F003 Source: OnError Description: Changing the name of a variable failed because it is a system variable. System variables are read-only. End ... The package execution fa... The step failed.
Im not modifying any system variables anywhere within the package, Ive double checked, system variables are all set to read only and no modification attempts are made. Why is it now failing, when it initially ran ok up to the server connection problem ?
Ive deleted the schedule and reset it, even stopped the server, nothing makes any difference, it just keeps failing.
Can anyone help ?
January 11, 2010 at 9:41 am
It sounds to me like something got stuck when it failed the first time. Have you tried simply rebooting the computer you're developing on, to see if that cleans it up?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 12, 2010 at 1:52 am
Ive rebooteed the machine, but it makes no difference, the job is still failing.
This makes no sense, it ran ok first time, all I did was change the server name in the config file. Im not trying to change a system variable anywhere in the package.
January 12, 2010 at 7:02 am
Sounds like you're getting an incorrect error message, but anything I say at this point would be guesswork. That sounds like something that'll require access to the actual code to debug.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply