Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: DTS Creation issue

    Hi all,

    Here is the problem : I can not create a DTS package in SQLServer.
    => Error description : access denied
    Environment :
    - Windows NT4 sp6 Server, french, logon on as "Administrator".
    - SQLServer 7.0 sp4, french, logon as "sa" on the NT Server with Enterprise Manager.
    - SQLServer Agent runs under an Administrator account

    Why can't i create single DTS package ? Strange, isn't it ?
    Many thanks for your ideas

    Bertrand

  2. #2
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42

    Re: DTS Creation issue

    Look for the latest Service Pack (I don't know the exact one but I think it's 3)

    Good luck.
    Shadow to Light

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Re: DTS Creation issue

    Actually it is the french sp4 for SQLServer 7.0 french.

    I can design a DTS package but i can not save it : "Access denied".
    Thanks for your help


    Originally posted by Crespo-n00b
    Look for the latest Service Pack (I don't know the exact one but I think it's 3)

    Good luck.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    On SQL ver7 SP4 is the last and latest despite of language.

    Can you try creating DTS package using DTS wizard.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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