Owner of DTS Package Cannot Edit Transform Task

[JohnBates]

hi people,
SQL Server 2000 SP4

I'm sure this problem has been posted before, but the Search tool is not working today.

A coworker wants to modify a package that I created and own.

Even after I changed the package owner to her login, she still is not able to view/modify the Transform Tasks within the package.

In the past, changing the owner almost always resolves any permissions issues, but not for this package.

These are the steps I ran to make her the package owner:

Use MSDB
sp_reassign_dtspackageowner @name = 'GM Load Planworks File', @id = '{72E17C29-0F0F-4712-86F4-5702D9DC68B6}',
@newloginname = 'MEM1\JBI0'


update sysdtspackages
set owner_sid = SUSER_SID('MEM1\JBI0'),
owner = 'MEM1\JBI0'
where name = 'GM Load Planworks File'

Anything else I can try?

Thanks, John

 

[mrdenny]

Have her disconnect from SQL and reconnect. The SQL 2000 tools often cache DTS info.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

mrdenny, we rebooted her PC. The problem remains.

This Transformation Task copies records from an Access table --> a SQL 2000 table.

I made her the owner of the package, to eliminate a permissions problem. And she can edit the Access database within Access.

The exact error message she gets when she tries to edit the Transformation Task is:

"Package Error: Source: JET Database Engine. The JET database engine cannot open the file ...... sonybmg.mdb.
It is already opened exclusively by another user, or you need permission to view its data."

I, and other developers, are able to edit this task. Only this one user gets this error.

This is 2000 SP4.

Has anyone encountered this error ?

Thank you.
John

 

[mrdenny]

If you double clicks on the access database directly does she get an errors?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnBates]

No, the Access db opens fine from he PC, her network login.

I think she has 2 versions of Access installed on her PC.

Could the DTS package be defaulting to the wrong version of Access when she tries to edit the task on her PC ?

Strange problem - I've never encountered it before.

Thanks for your time, mrdenny. John

 

[mrdenny]

That is entirly possible.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com