"Rea Peleg" <rea_p@afek.co.il> wrote in message news:<OEW8ylSLEHA.1416@TK2MSFTNGP09.phx.gbl>...
> I am totally lost on this one:
> I have a dts package which transforms data from tabula database into sql
> server through a propriatary odbc driver.
> When executed manually (through 'execute package') all is well, connection
> is made to both sides
> and data flows nicely.
> When I schedule this package to a job it ran but nothing happaned.. Not a
> single record
> retrieved, nor did I get any error massage. It just vanished after 1 second
> into thin air...
> Both the sqlserver and the sqlserveragent services are ran by the same user
> (a domain administrator) which is also the logged on user on
> the sqlserver machine.
> Sqlserver version is 2000 with sp installed.
> The server's os is windows server 2003 enterprise edition.
> Any ideas??
> At this stage any suggestions will be greatly appriciated.
> TIA
> Rea

"Rea Peleg" <rea_p@afek.co.il> wrote in message
news:OEW8ylSLEHA.1416@TK2MSFTNGP09.phx.gbl...
> I am totally lost on this one:
> I have a dts package which transforms data from tabula database into sql
> server through a propriatary odbc driver.
> When executed manually (through 'execute package') all is well, connection
> is made to both sides
> and data flows nicely.
> When I schedule this package to a job it ran but nothing happaned.. Not a
> single record
> retrieved, nor did I get any error massage. It just vanished after 1
second
> into thin air...
> Both the sqlserver and the sqlserveragent services are ran by the same
user
> (a domain administrator) which is also the logged on user on
> the sqlserver machine.
> Sqlserver version is 2000 with sp installed.
> The server's os is windows server 2003 enterprise edition.
> Any ideas??
> At this stage any suggestions will be greatly appriciated.
> TIA
> Rea
>
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uzv7z#aLEHA.2612@TK2MSFTNGP10.phx.gbl...
> OK I have had a similar problem and it is because it is actually erroring
> but the error does not bubble up to the job.
>
> Try logging onto the server as the SQL Server Agent Service account and
> executing the package manually. Work?
>
> Have the package log to text file
>
> It is firing right?
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Rea Peleg" <rea_p@afek.co.il> wrote in message
> news:OEW8ylSLEHA.1416@TK2MSFTNGP09.phx.gbl...
> > I am totally lost on this one:
> > I have a dts package which transforms data from tabula database into sql
> > server through a propriatary odbc driver.
> > When executed manually (through 'execute package') all is well,
connection
> > is made to both sides
> > and data flows nicely.
> > When I schedule this package to a job it ran but nothing happaned.. Not
a
> > single record
> > retrieved, nor did I get any error massage. It just vanished after 1
> second
> > into thin air...
> > Both the sqlserver and the sqlserveragent services are ran by the same
> user
> > (a domain administrator) which is also the logged on user on
> > the sqlserver machine.
> > Sqlserver version is 2000 with sp installed.
> > The server's os is windows server 2003 enterprise edition.
> > Any ideas??
> > At this stage any suggestions will be greatly appriciated.
> > TIA
> > Rea
> >
> >
> >
>
>