Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2008 > BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
|
BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
This is the forum to discuss the Wrox book Microsoft SQL Server 2008 Integration Services Problem-Design-Solution by Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney ; ISBN: 978-0-470-52576-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 18th, 2013, 03:57 PM
Registered User
 
Join Date: Mar 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default deadlock error on User::PackageLogID in Task SQL – LogVariableValueChanged

I am getting the error below. I have gone over the book several times and cannot see what I am doing wrong. The error does not seem to adversely impact the operation of the SSIS package, but I would like to get the problem fixed. Other procedures use the same variable without a problem. It is only on the Task SQL – LogVariableValueChanged.

Task SQL – LogVariableValueChanged
Error: A deadlock was detected while trying to lock variable "User::PackageLogID" for read access. A lock could not be acquired after 16 attempts and timed out.
[SQL Task] Error: Variable "User::PackageLogID" does not exist.





Similar Threads
Thread Thread Starter Forum Replies Last Post
LogVariableValueChanged error robhale BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution 1 August 27th, 2010 05:05 PM
SQL user instance error ckerin BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 April 28th, 2008 12:30 AM
Using multiple SPs in one "Execute SQL Task" yukito SQL Server DTS 2 January 3rd, 2008 12:53 AM
Continuing DEADLOCK Problem Ron Howerton SQL Server ASP 1 September 21st, 2005 02:55 PM
DEADLOCK issue - URGENT! Ron Howerton SQL Server ASP 3 August 9th, 2005 04:33 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.