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

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


    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


  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    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

    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]

    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


  4. #4
    Join Date
    Jan 2005
    Green Bay
    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