October 19, 2012 at 4:56 am
I have my package which runs with no errors in BIDS. But when I schedule a job to run the package, I get the following error right at the end of the package execution
Description: Failed to lock variable "User::Server_list" for read access with error 0xC0010001
User::Server_list is a variable I no longer use and I replaced it with something else. For some screwed up reason , SSIS still thinks this variable is being used but I've gone through every single component in my package and I can't find a reference to this variable. In fact it's not even in my variable list!
I also have no breakpoints and the CheckpointfileName package property is blank.
Maybe I'm missing something but is there a way to make SSIS display all variables used?! The package does contain a lot of components so maybe I've missed one somewhere but then surely the package would have failed in BIDS?!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 19, 2012 at 6:42 am
Maybe I'm missing something but is there a way to make SSIS display all variables used?! The package does contain a lot of components so maybe I've missed one somewhere but then surely the package would have failed in BIDS?!
You can view the XML behind the SSIS package, and then do a Find on the variable name (User::Server_list).
So if you right click on your SSIS package in Solution Explorer (in BIDS) and click "View Code" then you should see the XML.
/>L
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 19, 2012 at 7:39 am
Yea thanks. I've been trying to view the XML but Visual Studio seems to crash. It's a large package with many components.
I will keep trying and see what happens.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 19, 2012 at 7:46 am
Abu Dina (10/19/2012)
Yea thanks. I've been trying to view the XML but Visual Studio seems to crash. It's a large package with many components.I will keep trying and see what happens.
You can view the XML by opening the .dtsx file for the package in any XML editor you like. Notepad++ should be able to handle it.
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 19, 2012 at 7:54 am
I opened the package in NotePad++ but when I search for the variable it's not there!
This is just typical SSIS bull$h!t.
I've resolved the issue!
I found a loose Execute SQL Task that was hidden by a large Foreach loop container! Found it when I highlighted all components then I saw an outline for a box that didn't look like part of anything! lol :w00t:
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 19, 2012 at 8:03 am
Abu Dina (10/19/2012)
I opened the package in NotePad++ but when I search for the variable it's not there!This is just typical SSIS bull$h!t.
Hmm strange, only other thing I can think of is that maybe you have a reference to this variable in the SSIS configuration file you are using on the server, which is different from the configuration file you have setup in BIDS. Is that possible?
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 19, 2012 at 8:06 am
I have resolved the problem, see my edited reply above.
Thanks for your help.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 19, 2012 at 9:10 am
I've done that before :w00t:
Found it the same way.
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply