> So, my question is, what could be causing that a DTS package running from
> a Job Task transfers no records and when I run it directly from Data
> Transformation Services --> Local Packages, it transfers the right data
> (between 180 and 200 records depending on the day, but NEVER 0 records)
>
> is it permissions? it it something else? (btw, my DTS package doesn't need
> parameters or anything like that)

If you run the package remotely using Enterprise Manager, it runs on the
client machine. However, the package runs on the sever when launched via a
job. Perhaps this is reason for the difference.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"segis bata" <segisbata@hotmail.com> wrote in message
news:u6xcRrWWIHA.4896@TK2MSFTNGP06.phx.gbl...
> Hello all,
>
> I have this situation, I have a DTS package consisting of a series of data
> transformations and data transfers from our server to remote servers. If I
> execute the DTS from the Data Transformation Services --> Local Packages,
> it runs smoothly without any problems. But, when I schedule that same DTS
> package and have SQL (Server 2000) run it as a task on a daily manner it
> runs "successfully" (according to SQL) but when I see the job history I
> see that no records were transferred even though it says "successfully"
> (which, obviously, isn't)
>
> So, my question is, what could be causing that a DTS package running from
> a Job Task transfers no records and when I run it directly from Data
> Transformation Services --> Local Packages, it transfers the right data
> (between 180 and 200 records depending on the day, but NEVER 0 records)
>
> is it permissions? it it something else? (btw, my DTS package doesn't need
> parameters or anything like that)
>
> Thanks in advance for all your help,
> SB-R
>