Wednesday, March 21, 2012

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

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

Good luck.|||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.|||On SQL ver7 SP4 is the last and latest despite of language.

Can you try creating DTS package using DTS wizard.

No comments:

Post a Comment