Re: DTS package executed successfully but no data
From: Subbaiahd (subbaiahd_at_hotmail.com)
Date: 01/20/05
- Next message: AAugusto: "BCP limit"
- Previous message: Toby: "Please Help - Transactions won't work in DTS if executed from another machine"
- In reply to: Allan Mitchell: "Re: DTS package executed successfully but no data"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 Jan 2005 12:01:37 -0500
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@no-spam.sqldts.com> wrote in message
news:%232S0RYm$EHA.3988@TK2MSFTNGP11.phx.gbl...
> 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@hotmail.com> wrote in message
> news:eJAGVCk$EHA.2880@TK2MSFTNGP14.phx.gbl...
> > 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.
> >
> >
> >
>
>
- Next message: AAugusto: "BCP limit"
- Previous message: Toby: "Please Help - Transactions won't work in DTS if executed from another machine"
- In reply to: Allan Mitchell: "Re: DTS package executed successfully but no data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
