August 29, 2010 at 12:16 am
Here is the error code I am receiving...
SSIS package "SecUserRole_SSIS.dtsx" starting.
Error: 0xC002F210 at Drop User - MDDBADMIN, Execute SQL Task: Executing the query "" failed with the following error: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Drop User - MDDBADMIN
SSIS package "SecUserRole_SSIS.dtsx" finished: Success.
Here is the script I am trying to run...
USE [QA42]
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'MDDBADMIN')
DROP USER [MDDBADMIN]
The SQL code executes fine on the server, but when the package runs it fails. Any thoughts?
August 30, 2010 at 6:55 am
Does SSIS have the proper authority to drop a user?
August 30, 2010 at 2:49 pm
I had no problems with this SQL in SSIS until Saturday. I was able to drop and create flawlessly. Something happened and it caused it stop working. I have no idea why...
August 30, 2010 at 6:13 pm
I figured it out. I was using a Control Flow Item called Execute SQL Task. That failed for all three users I was trying to drop. I switched to a Maintenance Plan Task of Execute T-SQL Statement Task and the package ran like a charm. 😀
September 1, 2010 at 1:37 am
Glad you got it sorted.
Your solution would indicate a problem with user rights as previously suggested. If i am not mistaken you need to use a different connection to execute something for the Execute SQL Task then the Maintenance Plan task. I would have a look at the rights of these user just for piece of mind.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply