I know that I have to schedule a DTS package under an account which is in
sysadmin role in order not to face security problems.Dose sysadmin role mean
System administator?

What type of account you guys use for you oleDBConnections insode the
packages Sqlserver accoun or domain account? if sql server what kind of role
that account belongs to>?

Thanks a lot

sysadmin means God in SQL Server

It does not mean you will avoid all the security problems. If the job is
owned by a sysadmin then the job will fire as the Service account. What if
the service account is a Local System account? It cannot see off its own
HDD so will not be able to get resources from the network etc.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"J-T" <JT (AT) nospam (DOT) com> wrote

I didn't get it.Sorry
If you want to schadule a DTS package to run everyday ,which account do you
use for that?

Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Any job owned by any user can run every day.

Have a read of this

http://support.microsoft.com/?kbid=269074

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"J-T" <JT (AT) nospam (DOT) com> wrote