Re: Approaches!
From: Karthik R (dtsguy1_at_rediffmail.com)
Date: 10/16/04
- Next message: Hari Prasad: "Re: How to create table from existing table structure?"
- Previous message: Darren Green: "Re: Output Parameter To Global Variable (DTS)"
- In reply to: Allan Mitchell: "Re: Approaches!"
- Messages sorted by: [ date ] [ thread ]
Date: 16 Oct 2004 11:13:47 -0700
Thanks very much Allan.
Karthik
"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:<usLtdlerEHA.376@TK2MSFTNGP14.phx.gbl>...
> 1 Correct. Make sure the account has only those permissions it requires.
> 2. DTSRUNUI is there to help you construct the DTSRUN command. It takes
> your inputs and builds the string necessary.
>
> The preferred method of communication between resources is a Trusted
> connection.
>
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.Konesans.com
>
>
> "Karthik R" <dtsguy1@rediffmail.com> wrote in message
> news:d30961f9.0410081048.44ebd8a3@posting.google.com...
> > Hi
> >
> > I have a few questions on DTS packages!
> >
> > 1. Scheduling DTS Job - Security
> >
> > If i need to schedule the dts job as a non System administrator login,
> > i need to create a sql agent proxy acnt. All permissions for the
> > package will be the proxy acnt permissions. Is this correct? Any
> > warnings here?
> >
> >
> > 2. Passing Password to DTS Job - DTSRUN
> >
> > I want to dynamically set the password from some external source for
> > DTS connections. I can use UDL files - but it stores plain text
> > password. (Which is not secure).
> >
> > I did some google and found out that DTSRUN supports launching of
> > packages and with switches for global parameters and encrypted
> > password provision! There is a utility DTSRUNUI. Can i use this to
> > schedule and pass sql server login and password to package level
> > global variable?
> >
> > And will this affect the previous question?
> >
> > Thanks!
- Next message: Hari Prasad: "Re: How to create table from existing table structure?"
- Previous message: Darren Green: "Re: Output Parameter To Global Variable (DTS)"
- In reply to: Allan Mitchell: "Re: Approaches!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
