DTS Problem

Hi,
When i create a DTS and schedule it, the DTS don't run, but if i run this
DTS using the SQL Enterprise manager, everything works fine! Is it a
permission problem ? A Scheduled DTS must have a specific permission ?
Thanks in advance,
VictorDid you start SQL Server Agent ?
Jens Suessmeyer.
"Victor Pereira" <taintmode@.yahoo.com.br> schrieb im Newsbeitrag
news:eLIohxRRFHA.3296@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>|||From BOL
Usually, a package run from DTS Designer, the DTS Import/Export Wizard, the
DTS Run utility, or from the command prompt executes under the security
context of the user who is currently logged in. However, a package scheduled
for execution runs under the security context of the SQL Server Agent job
that runs the package.
"Victor Pereira" wrote:

> Hi,
> When i create a DTS and schedule it, the DTS don't run, but if i run this
> DTS using the SQL Enterprise manager, everything works fine! Is it a
> permission problem ? A Scheduled DTS must have a specific permission ?
> Thanks in advance,
> Victor
>
>|||My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
Agent scheduled jobs run on the SQL Server, while interactive ones execute
on the same system on which they were launched. So, when i run the
interactive job, i read the local C:\foobar.csv and everyting works! But
scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
file won't exist so, the process fail! Am i right ?
Thanks in advance,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> From BOL
> Usually, a package run from DTS Designer, the DTS Import/Export Wizard,
the
> DTS Run utility, or from the command prompt executes under the security
> context of the user who is currently logged in. However, a package
scheduled[vbcol=seagreen]
> for execution runs under the security context of the SQL Server Agent job
> that runs the package.
>
> "Victor Pereira" wrote:
>
this[vbcol=seagreen]|||Yes. If you need to read a remote file, make share on remote location, set
appropriate permission for SQL Server Agent Service and in your DTS specify
UNC name for that file (\\Server\Share\foobar.csv)
Hope this help
"Victor Pereira" wrote:

> My DTS read a file C:\foobar.csv and import it into SQL Server. SQL Server
> Agent scheduled jobs run on the SQL Server, while interactive ones execute
> on the same system on which they were launched. So, when i run the
> interactive job, i read the local C:\foobar.csv and everyting works! But
> scheduled job will try to open a C:\foobar.csv at the SQL Server, but this
> file won't exist so, the process fail! Am i right ?
> Thanks in advance,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:A20074DA-3522-406D-87EA-B96655E34A8A@.microsoft.com...
> the
> scheduled
> this
>
>|||Hi Ana,
But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
scheduled job will try to open the local C:\foobar.csv right ?
Thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> Yes. If you need to read a remote file, make share on remote location, set
> appropriate permission for SQL Server Agent Service and in your DTS
specify[vbcol=seagreen]
> UNC name for that file (\\Server\Share\foobar.csv)
> Hope this help
> "Victor Pereira" wrote:
>
Server[vbcol=seagreen]
execute[vbcol=seagreen]
this[vbcol=seagreen]
Wizard,[vbcol=seagreen]
security[vbcol=seagreen]
job[vbcol=seagreen]
?[vbcol=seagreen]|||If your DTS is saved on SQL server on your local machine, yes. But if your
DTS is on remote server, then your DTS will run on remote machine and with
account specified in dtsrun.exe command.
"Victor Pereira" wrote:

> Hi Ana,
> But if i schedule at my local machine using (at.exe + dtsrun.exe) then my
> scheduled job will try to open the local C:\foobar.csv right ?
> Thanks,
> Victor
> "Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
> news:78E6E68E-4267-4C6F-8657-0B10DDCC3974@.microsoft.com...
> specify
> Server
> execute
> this
> Wizard,
> security
> job
> ?
>
>|||Ana, thanks for your help, i solved this "misterious" problem, god bless you
;-)
thanks,
Victor
"Ana Mihalj" <AnaMihalj@.discussions.microsoft.com> wrote in message
news:2A1013F8-EEE1-4EA7-98B2-40FE38ACA849@.microsoft.com...
> If your DTS is saved on SQL server on your local machine, yes. But if your
> DTS is on remote server, then your DTS will run on remote machine and
with[vbcol=seagreen]
> account specified in dtsrun.exe command.
> "Victor Pereira" wrote:
>
my[vbcol=seagreen]
set[vbcol=seagreen]
But[vbcol=seagreen]
but[vbcol=seagreen]
Agent[vbcol=seagreen]
run[vbcol=seagreen]
it a[vbcol=seagreen]
permission[vbcol=seagreen]