DTS load jobs executed successfuly but no data.

I have dts paackages for loading data from one sql server database to
another sql server database, there are 8 tables being loaded daily and they
run by sql server agent job. I used simple simple copy transformation on all
tables. I have used an exception file to capture exceptions that occured
during load. I have see exception file it has tags
Execution Started: 1/18/2005 11:25:36 PM
Execution Completed: 1/18/2005 11:25:52 PM

I also have enabled logging, i have gone thru all logs, there is no error at
all. Everything looks fine but no data in tables. These packages have been
running fine daily till the date, no changes to the package.

I started it manually it is going good. I am not sure what is causing the
problem, can you please help.

Thanks,
SUbbu.

Sometimes the errors do not get bubbled up. Remember that just because you
can execute it does not mean that the SQL Server Agent service account can
or the Proxy Account

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


Have a look at logging in to the server manaually as the appropriate account
antry executing the package.

Still work?

--



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


"Subbaiahd" <subbaiahd (AT) hotmail (DOT) com> wrote

Thank you Allan, I saw Server Logging , but no error msg, all i saw was
successfully executed msgs. I have complex issues erlier with accounts, that
might have caused it. I am going to dig into it more.

I am working from USA.

Thanks,
Subbu.


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