Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    3

    Unanswered: Need help Unable to execute a DTS with SA privilages

    Hi

    I fighting with a strange problem with a DTS package, we had a DTS package under a name of user who left the company and his account was deactivated, i openned that DTS package and saved it under my name and my user is part of sysadmin role, when i am trying to execute the DTS i gets the error message permission denied unable to create table (database name)
    while i can crete/delete tables in that particular database manualy via query analyser as well as through enterprise manager but when i am trying to do that through a DTS as mentioned above i always gets the permission denied message
    any help will be highly appreciated
    thanks

    Ramis

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Have you checked to see if the table already exists?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    May 2006
    Posts
    3

    droped the table first

    Thanks for your reply
    i am already checking for the existence of the table

    if exists (select * from sysobjects where id = object_id(N'[dbo].[~tblLkupPlg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
    drop table [dbo].[~tblLkupPlg]
    GO

    and then trying to create it
    and i am getting an error message permission is denied to create table
    although i have rights to create table, i created tables manualy without any problem in the same database

    i just saved the existing DTS under my username by using the SAVE AS option of file menu
    rest is same

    any idea what need to be checked further,
    appreciate your help

    Ramis

  4. #4
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    I would check the connections in the DTS one may be hard coded with his userid/password.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •