Post reply

DTSRun utility

  • April 15, 2003 at 11:36 am

    #105953

    I have a created a DTS pkg and I try to schedule the DTS pkg in SQL job using the DTSrun utility.

    Could you tell me How can I encrypt the Username & password in teh DTSrun stmt

    DTSRun /SSvrname /Usa /P12345/NDTSEnd_Inv_Source

    I have given permission for couple of users to access the SQL job(Steps too) and I don't want them to see the sa password.

    Could you tell me how?

    PS:

    I don't want to create the schedule for the DTS pkg thro' EM,B'caz itz hard to understand and maintain the pkg.

  • April 16, 2003 at 7:31 am

    #454351

    Have you tried to use /E parameter run packages under windows authentication?

  • April 16, 2003 at 9:40 am

    #454386

    I havn't tried before.

    We don't allow the NT a/c to execute the DTS pkg.Anyway I will try.Could you tell me the Syntax for using /E in the DTSrun utility?

  • April 16, 2003 at 9:42 am

    #454387

    Basically, there is no difference except you don't have to add parameters for login and password. For details, See BOL "dtsrun Utility".

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply