Hello

I am required to monitor the logs of various DTS packages in my organization
every day and so far I have been doing this manually. Recently, I discovered
that vb.net can automate this for me with the use of GetPackageSQLServer
method. And I tested this out on my local installation of SQL Server. The
program I wrote, logged on to the local database, extracted the logs of the
DTS packages and published them on the screen for me.

Now when I try to connect to the production SQL Server instance, I dont get
any error message but I also dont get any logs. While I know for a fact that
there are over 4000 logs on that machine. I have checked all the connection
parameters etc and everything is fine. I wonder if it has anything to do
with permissions

Next, I tried to replace the login id that I connect with in the code with
my Windows Login id e.g. domain\username.. but during execution I always
receive the error message that login failed. Is there any special way in
which I must specify the login id???

Thanks in advance.

"Paul McKenna" <pmckenna9999 (AT) nospam (DOT) yahoo.com> wrote