DTS packages fail after server migration

Hi All
My DTS packages fail after i have migrated my sql server from a NT based
network to a windows 2003 based network and unattached the old domain, I
know that the users that was once on the server as %old domain%\user will no
longer have any rights on the sql server, But how can i change the ownership
of those DTS packages to %New Domain%\New AD User.?
some input would be great.
thanksHave you checked SQLDTS.com. I believe package ownership issues are covered
on that site.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Todd" <Todd_c_wright@.hotmail.com> wrote in message
news:uVew3tSDEHA.3348@.TK2MSFTNGP11.phx.gbl...
Hi All
My DTS packages fail after i have migrated my sql server from a NT based
network to a windows 2003 based network and unattached the old domain, I
know that the users that was once on the server as %old domain%\user will no
longer have any rights on the sql server, But how can i change the ownership
of those DTS packages to %New Domain%\New AD User.?
some input would be great.
thanks|||You can change the owner using the undocumented
sp_reassign_dtspackageowner but the package ownership
probably has nothing to do with the packages failing. You
can sometimes run into issues when someone who isn't the
owner and isn't a sysadmin attempts to modify and save
packages owned by someone else but that's about it.
You can find more info on this at the site Vyas referred you
to:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212
Are these scheduled packages that are failing or do they
fail when run manually as well? What are the errors?
-Sue
On Fri, 19 Mar 2004 09:56:27 +1300, "Todd"
<Todd_c_wright@.hotmail.com> wrote:

>Hi All
>My DTS packages fail after i have migrated my sql server from a NT based
>network to a windows 2003 based network and unattached the old domain, I
>know that the users that was once on the server as %old domain%\user will n
o
>longer have any rights on the sql server, But how can i change the ownershi
p
>of those DTS packages to %New Domain%\New AD User.?
> some input would be great.
> thanks
>

DTS Packages (.dtsx) and Automation through C#

I have spent the last couple of weeks going through about 15-20 different examples/tutorials on running DTS packages from inside a C# Windows app (and even asp.net). I must have a mental block, because I can't seem to make it click in my head. I have hundreds of DTS packages saved as .dtsx files. I can double click on them and run them perfectly. What I need to do is be able to run them conditionally from inside a windows app. Could anyone point me to a tutorial or example that could help me with this? I've even looked at some VB source to see if I could work it out, but I keep running up against a wall. I'd appreciate any help anyone can provide.

I just realized, if there is a better forum for me to post this in, please let me know that also.

dts packages

hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KPHave a look at
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
hi
I have my database & dts packages are on sql 7.0 with
windows nt4.0. I am moving the database to sql 2000.
Database part I am quite sure how to proceed. How do I go
about moving or for that matter to copy the dts packages
to sql 2000. any help in this regard is appreciated
thanks
KP|||Hi,
If there are not many packages, you can open them individually and do a
'package| Save as ' pointing to the SQL2000 server.If not, try to transfer
the packages directly between
sysdtspackages(http://www.sqldts.com/main.asp?nav=1,6,204,0)
Also, you can use a tool called ScriptPkg which is present in the SQL Server
setup CD.This tool can script your packages to VB code which can be then
executed against SQL2000.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"KP" <me@.mydomain.com> wrote in message
news:00bb01c35aa7$bdfe6530$a401280a@.phx.gbl...
> hi
> I have my database & dts packages are on sql 7.0 with
> windows nt4.0. I am moving the database to sql 2000.
> Database part I am quite sure how to proceed. How do I go
> about moving or for that matter to copy the dts packages
> to sql 2000. any help in this regard is appreciated
> thanks
> KP

DTS opening error on server enterprise manager

We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
created some DTS on this server which were scheduled to run on perticular
time. Few days back all the DTS started failing to execute through scheduler.
While checking from any client machine the DTS is running successfully but on
the server machine it is not. When I tried to open the DTS on the server
console Enterprise Manager it is giving me following error
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
does not exists or access denied
I had tried with reinstalling the SQL Enterprise manager on the server,
reregistered the SQLDMO.dll but without any success.
Can anybody help me?
Hi
It is probably you creared the DTS on your workstation and not on the
server. If you schedule the DTS to run as a job it will be ran under SQL
Server Agent account. Check it out.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
had
> created some DTS on this server which were scheduled to run on perticular
> time. Few days back all the DTS started failing to execute through
scheduler.
> While checking from any client machine the DTS is running successfully but
on
> the server machine it is not. When I tried to open the DTS on the server
> console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> does not exists or access denied
> I had tried with reinstalling the SQL Enterprise manager on the server,
> reregistered the SQLDMO.dll but without any success.
>
> Can anybody help me?
>
>
>
|||It is created from the workstation but on the server. That means it is saved
on the server and scheduled on the server under SQlserver Agent account. It
was running still last few days. Now it is giving the problem. it is not
giving me access to open the package also. it is giving me the error that I
had written.
"Uri Dimant" wrote:

> Hi
> It is probably you creared the DTS on your workstation and not on the
> server. If you schedule the DTS to run as a job it will be ran under SQL
> Server Agent account. Check it out.
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> had
> scheduler.
> on
>
>
|||Well,that means that something was changed (an account, a password)
Are you sure?
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> It is created from the workstation but on the server. That means it is
saved
> on the server and scheduled on the server under SQlserver Agent account.
It
> was running still last few days. Now it is giving the problem. it is not
> giving me access to open the package also. it is giving me the error that
I[vbcol=seagreen]
> had written.
>
>
> "Uri Dimant" wrote:
We[vbcol=seagreen]
perticular[vbcol=seagreen]
but[vbcol=seagreen]
server[vbcol=seagreen]
Server[vbcol=seagreen]
server,[vbcol=seagreen]
|||No there is no changes happend, I am able to Open the package and execute the
package from my client pc. But while doing the same on the sever console it
is giving me error. I am convienced that scheduler is not able to run the
package as server is giving the error.
This error is comming only on the Server's Enterprise Manager, not on any
client side.
"Uri Dimant" wrote:

> Well,that means that something was changed (an account, a password)
> Are you sure?
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> saved
> It
> I
> We
> perticular
> but
> server
> Server
> server,
>
>
|||Still the only logical reason can be that there somehow is a difference
between your client and the server.
How do you log on on the server when you try to open the DTS via Enterprise
Mgr? Using your own account or rather via a (local) admin account on that
machine ?
If the latter, check if the sql-connection you speak about is based on a
Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
should verify (or even beter : try to simulate) the account used for
running the SQLAgent is able to connect to the requested database. Likely
something has changed the past week, they just forgot to tell you =)
Good Luck,
Roby
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...[vbcol=seagreen]
> No there is no changes happend, I am able to Open the package and execute
> the
> package from my client pc. But while doing the same on the sever console
> it
> is giving me error. I am convienced that scheduler is not able to run the
> package as server is giving the error.
> This error is comming only on the Server's Enterprise Manager, not on any
> client side.
> "Uri Dimant" wrote:
|||In regards to the packages failing, you need to check the
job history for the DTS packages to determine why they are
failing. Checking the details in the job history will give
you more detailed information on why the packages are
failing to run as schedule.
-Sue
On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
<satyaki@.discussions.microsoft.com> wrote:

>We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
>created some DTS on this server which were scheduled to run on perticular
>time. Few days back all the DTS started failing to execute through scheduler.
>While checking from any client machine the DTS is running successfully but on
>the server machine it is not. When I tried to open the DTS on the server
>console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
>does not exists or access denied
>I had tried with reinstalling the SQL Enterprise manager on the server,
>reregistered the SQLDMO.dll but without any success.
>
>Can anybody help me?
>
>
>
|||I had already checked that, it is giving same error server does not exists or
access denied. this is only happening on the server console enterprise
manager.
I don't thing it is any secured connection problem, nobody has change any
server configurations. Other activity on the enterprise manager is running
perfectly. I am facing this problem only on DTS package opening, may be due
to this the job scheduler is not running as job history is showing the same
problem.
"Sue Hoegemeier" wrote:

> In regards to the packages failing, you need to check the
> job history for the DTS packages to determine why they are
> failing. Checking the details in the job history will give
> you more detailed information on why the packages are
> failing to run as schedule.
> -Sue
> On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
> <satyaki@.discussions.microsoft.com> wrote:
>
>
|||i am using sa login in the server enterprise manager to open the DTS. i had
tried with windows authentication, DTS creators login but without any result.
And no body has change any settings on the server/
"Roby Van Hoye" wrote:

> Still the only logical reason can be that there somehow is a difference
> between your client and the server.
> How do you log on on the server when you try to open the DTS via Enterprise
> Mgr? Using your own account or rather via a (local) admin account on that
> machine ?
> If the latter, check if the sql-connection you speak about is based on a
> Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
> should verify (or even beter : try to simulate) the account used for
> running the SQLAgent is able to connect to the requested database. Likely
> something has changed the past week, they just forgot to tell you =)
> Good Luck,
> Roby
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
>
>

DTS opening error on server enterprise manager

We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
created some DTS on this server which were scheduled to run on perticular
time. Few days back all the DTS started failing to execute through scheduler.
While checking from any client machine the DTS is running successfully but on
the server machine it is not. When I tried to open the DTS on the server
console Enterprise Manager it is giving me following error
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
does not exists or access denied
I had tried with reinstalling the SQL Enterprise manager on the server,
reregistered the SQLDMO.dll but without any success.
Can anybody help me'Hi
It is probably you creared the DTS on your workstation and not on the
server. If you schedule the DTS to run as a job it will be ran under SQL
Server Agent account. Check it out.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
had
> created some DTS on this server which were scheduled to run on perticular
> time. Few days back all the DTS started failing to execute through
scheduler.
> While checking from any client machine the DTS is running successfully but
on
> the server machine it is not. When I tried to open the DTS on the server
> console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> does not exists or access denied
> I had tried with reinstalling the SQL Enterprise manager on the server,
> reregistered the SQLDMO.dll but without any success.
>
> Can anybody help me'
>
>
>|||It is created from the workstation but on the server. That means it is saved
on the server and scheduled on the server under SQlserver Agent account. It
was running still last few days. Now it is giving the problem. it is not
giving me access to open the package also. it is giving me the error that I
had written.
"Uri Dimant" wrote:
> Hi
> It is probably you creared the DTS on your workstation and not on the
> server. If you schedule the DTS to run as a job it will be ran under SQL
> Server Agent account. Check it out.
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> > We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
> had
> > created some DTS on this server which were scheduled to run on perticular
> > time. Few days back all the DTS started failing to execute through
> scheduler.
> > While checking from any client machine the DTS is running successfully but
> on
> > the server machine it is not. When I tried to open the DTS on the server
> > console Enterprise Manager it is giving me following error
> > Error Source : Microsoft OLE DB Provider for SQL Server
> > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> > does not exists or access denied
> > I had tried with reinstalling the SQL Enterprise manager on the server,
> > reregistered the SQLDMO.dll but without any success.
> >
> >
> >
> > Can anybody help me'
> >
> >
> >
> >
> >
> >
>
>|||Well,that means that something was changed (an account, a password)
Are you sure?
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> It is created from the workstation but on the server. That means it is
saved
> on the server and scheduled on the server under SQlserver Agent account.
It
> was running still last few days. Now it is giving the problem. it is not
> giving me access to open the package also. it is giving me the error that
I
> had written.
>
>
> "Uri Dimant" wrote:
> > Hi
> > It is probably you creared the DTS on your workstation and not on the
> > server. If you schedule the DTS to run as a job it will be ran under SQL
> > Server Agent account. Check it out.
> >
> >
> >
> >
> > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> > > We have got a SQL server 2000 loaded on a Windows 2000 advance server.
We
> > had
> > > created some DTS on this server which were scheduled to run on
perticular
> > > time. Few days back all the DTS started failing to execute through
> > scheduler.
> > > While checking from any client machine the DTS is running successfully
but
> > on
> > > the server machine it is not. When I tried to open the DTS on the
server
> > > console Enterprise Manager it is giving me following error
> > > Error Source : Microsoft OLE DB Provider for SQL Server
> > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
Server
> > > does not exists or access denied
> > > I had tried with reinstalling the SQL Enterprise manager on the
server,
> > > reregistered the SQLDMO.dll but without any success.
> > >
> > >
> > >
> > > Can anybody help me'
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >|||No there is no changes happend, I am able to Open the package and execute the
package from my client pc. But while doing the same on the sever console it
is giving me error. I am convienced that scheduler is not able to run the
package as server is giving the error.
This error is comming only on the Server's Enterprise Manager, not on any
client side.
"Uri Dimant" wrote:
> Well,that means that something was changed (an account, a password)
> Are you sure?
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> > It is created from the workstation but on the server. That means it is
> saved
> > on the server and scheduled on the server under SQlserver Agent account.
> It
> > was running still last few days. Now it is giving the problem. it is not
> > giving me access to open the package also. it is giving me the error that
> I
> > had written.
> >
> >
> >
> >
> > "Uri Dimant" wrote:
> >
> > > Hi
> > > It is probably you creared the DTS on your workstation and not on the
> > > server. If you schedule the DTS to run as a job it will be ran under SQL
> > > Server Agent account. Check it out.
> > >
> > >
> > >
> > >
> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> > > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> > > > We have got a SQL server 2000 loaded on a Windows 2000 advance server.
> We
> > > had
> > > > created some DTS on this server which were scheduled to run on
> perticular
> > > > time. Few days back all the DTS started failing to execute through
> > > scheduler.
> > > > While checking from any client machine the DTS is running successfully
> but
> > > on
> > > > the server machine it is not. When I tried to open the DTS on the
> server
> > > > console Enterprise Manager it is giving me following error
> > > > Error Source : Microsoft OLE DB Provider for SQL Server
> > > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
> Server
> > > > does not exists or access denied
> > > > I had tried with reinstalling the SQL Enterprise manager on the
> server,
> > > > reregistered the SQLDMO.dll but without any success.
> > > >
> > > >
> > > >
> > > > Can anybody help me'
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
>
>|||Still the only logical reason can be that there somehow is a difference
between your client and the server.
How do you log on on the server when you try to open the DTS via Enterprise
Mgr? Using your own account or rather via a (local) admin account on that
machine ?
If the latter, check if the sql-connection you speak about is based on a
Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
should verify (or even beter : try to simulate) the account used for
running the SQLAgent is able to connect to the requested database. Likely
something has changed the past week, they just forgot to tell you =)
Good Luck,
Roby
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
> No there is no changes happend, I am able to Open the package and execute
> the
> package from my client pc. But while doing the same on the sever console
> it
> is giving me error. I am convienced that scheduler is not able to run the
> package as server is giving the error.
> This error is comming only on the Server's Enterprise Manager, not on any
> client side.
> "Uri Dimant" wrote:
>> Well,that means that something was changed (an account, a password)
>> Are you sure?
>>
>>
>> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
>> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
>> > It is created from the workstation but on the server. That means it is
>> saved
>> > on the server and scheduled on the server under SQlserver Agent
>> > account.
>> It
>> > was running still last few days. Now it is giving the problem. it is
>> > not
>> > giving me access to open the package also. it is giving me the error
>> > that
>> I
>> > had written.
>> >
>> >
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> > > Hi
>> > > It is probably you creared the DTS on your workstation and not on the
>> > > server. If you schedule the DTS to run as a job it will be ran under
>> > > SQL
>> > > Server Agent account. Check it out.
>> > >
>> > >
>> > >
>> > >
>> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
>> > > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
>> > > > We have got a SQL server 2000 loaded on a Windows 2000 advance
>> > > > server.
>> We
>> > > had
>> > > > created some DTS on this server which were scheduled to run on
>> perticular
>> > > > time. Few days back all the DTS started failing to execute through
>> > > scheduler.
>> > > > While checking from any client machine the DTS is running
>> > > > successfully
>> but
>> > > on
>> > > > the server machine it is not. When I tried to open the DTS on the
>> server
>> > > > console Enterprise Manager it is giving me following error
>> > > > Error Source : Microsoft OLE DB Provider for SQL Server
>> > > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
>> Server
>> > > > does not exists or access denied
>> > > > I had tried with reinstalling the SQL Enterprise manager on the
>> server,
>> > > > reregistered the SQLDMO.dll but without any success.
>> > > >
>> > > >
>> > > >
>> > > > Can anybody help me'
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> > >
>>|||In regards to the packages failing, you need to check the
job history for the DTS packages to determine why they are
failing. Checking the details in the job history will give
you more detailed information on why the packages are
failing to run as schedule.
-Sue
On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
<satyaki@.discussions.microsoft.com> wrote:
>We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
>created some DTS on this server which were scheduled to run on perticular
>time. Few days back all the DTS started failing to execute through scheduler.
>While checking from any client machine the DTS is running successfully but on
>the server machine it is not. When I tried to open the DTS on the server
>console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
>does not exists or access denied
>I had tried with reinstalling the SQL Enterprise manager on the server,
>reregistered the SQLDMO.dll but without any success.
>
>Can anybody help me'
>
>
>|||I had already checked that, it is giving same error server does not exists or
access denied. this is only happening on the server console enterprise
manager.
I don't thing it is any secured connection problem, nobody has change any
server configurations. Other activity on the enterprise manager is running
perfectly. I am facing this problem only on DTS package opening, may be due
to this the job scheduler is not running as job history is showing the same
problem.
"Sue Hoegemeier" wrote:
> In regards to the packages failing, you need to check the
> job history for the DTS packages to determine why they are
> failing. Checking the details in the job history will give
> you more detailed information on why the packages are
> failing to run as schedule.
> -Sue
> On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
> <satyaki@.discussions.microsoft.com> wrote:
> >We have got a SQL server 2000 loaded on a Windows 2000 advance server. We had
> >created some DTS on this server which were scheduled to run on perticular
> >time. Few days back all the DTS started failing to execute through scheduler.
> >While checking from any client machine the DTS is running successfully but on
> >the server machine it is not. When I tried to open the DTS on the server
> >console Enterprise Manager it is giving me following error
> > Error Source : Microsoft OLE DB Provider for SQL Server
> > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server
> >does not exists or access denied
> >I had tried with reinstalling the SQL Enterprise manager on the server,
> >reregistered the SQLDMO.dll but without any success.
> >
> >
> >
> >Can anybody help me'
> >
> >
> >
> >
> >
>|||i am using sa login in the server enterprise manager to open the DTS. i had
tried with windows authentication, DTS creators login but without any result.
And no body has change any settings on the server/
"Roby Van Hoye" wrote:
> Still the only logical reason can be that there somehow is a difference
> between your client and the server.
> How do you log on on the server when you try to open the DTS via Enterprise
> Mgr? Using your own account or rather via a (local) admin account on that
> machine ?
> If the latter, check if the sql-connection you speak about is based on a
> Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
> should verify (or even beter : try to simulate) the account used for
> running the SQLAgent is able to connect to the requested database. Likely
> something has changed the past week, they just forgot to tell you =)
> Good Luck,
> Roby
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
> > No there is no changes happend, I am able to Open the package and execute
> > the
> > package from my client pc. But while doing the same on the sever console
> > it
> > is giving me error. I am convienced that scheduler is not able to run the
> > package as server is giving the error.
> >
> > This error is comming only on the Server's Enterprise Manager, not on any
> > client side.
> >
> > "Uri Dimant" wrote:
> >
> >>
> >> Well,that means that something was changed (an account, a password)
> >> Are you sure?
> >>
> >>
> >>
> >>
> >> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> >> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> >> > It is created from the workstation but on the server. That means it is
> >> saved
> >> > on the server and scheduled on the server under SQlserver Agent
> >> > account.
> >> It
> >> > was running still last few days. Now it is giving the problem. it is
> >> > not
> >> > giving me access to open the package also. it is giving me the error
> >> > that
> >> I
> >> > had written.
> >> >
> >> >
> >> >
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> > > Hi
> >> > > It is probably you creared the DTS on your workstation and not on the
> >> > > server. If you schedule the DTS to run as a job it will be ran under
> >> > > SQL
> >> > > Server Agent account. Check it out.
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> >> > > news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> >> > > > We have got a SQL server 2000 loaded on a Windows 2000 advance
> >> > > > server.
> >> We
> >> > > had
> >> > > > created some DTS on this server which were scheduled to run on
> >> perticular
> >> > > > time. Few days back all the DTS started failing to execute through
> >> > > scheduler.
> >> > > > While checking from any client machine the DTS is running
> >> > > > successfully
> >> but
> >> > > on
> >> > > > the server machine it is not. When I tried to open the DTS on the
> >> server
> >> > > > console Enterprise Manager it is giving me following error
> >> > > > Error Source : Microsoft OLE DB Provider for SQL Server
> >> > > > Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
> >> Server
> >> > > > does not exists or access denied
> >> > > > I had tried with reinstalling the SQL Enterprise manager on the
> >> server,
> >> > > > reregistered the SQLDMO.dll but without any success.
> >> > > >
> >> > > >
> >> > > >
> >> > > > Can anybody help me'
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

DTS opening error on server enterprise manager

We have got a SQL server 2000 loaded on a Windows 2000 advance server. We ha
d
created some DTS on this server which were scheduled to run on perticular
time. Few days back all the DTS started failing to execute through scheduler
.
While checking from any client machine the DTS is running successfully but o
n
the server machine it is not. When I tried to open the DTS on the server
console Enterprise Manager it is giving me following error
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Serve
r
does not exists or access denied
I had tried with reinstalling the SQL Enterprise manager on the server,
reregistered the SQLDMO.dll but without any success.
Can anybody help me'Hi
It is probably you creared the DTS on your workstation and not on the
server. If you schedule the DTS to run as a job it will be ran under SQL
Server Agent account. Check it out.
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> We have got a SQL server 2000 loaded on a Windows 2000 advance server. We
had
> created some DTS on this server which were scheduled to run on perticular
> time. Few days back all the DTS started failing to execute through
scheduler.
> While checking from any client machine the DTS is running successfully but
on
> the server machine it is not. When I tried to open the DTS on the server
> console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL
Server
> does not exists or access denied
> I had tried with reinstalling the SQL Enterprise manager on the server,
> reregistered the SQLDMO.dll but without any success.
>
> Can anybody help me'
>
>
>|||It is created from the workstation but on the server. That means it is saved
on the server and scheduled on the server under SQlserver Agent account. It
was running still last few days. Now it is giving the problem. it is not
giving me access to open the package also. it is giving me the error that I
had written.
"Uri Dimant" wrote:

> Hi
> It is probably you creared the DTS on your workstation and not on the
> server. If you schedule the DTS to run as a job it will be ran under SQL
> Server Agent account. Check it out.
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:7A71BBFA-C68A-4894-9466-39CFAC659F7B@.microsoft.com...
> had
> scheduler.
> on
>
>|||Well,that means that something was changed (an account, a password)
Are you sure?
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> It is created from the workstation but on the server. That means it is
saved
> on the server and scheduled on the server under SQlserver Agent account.
It
> was running still last few days. Now it is giving the problem. it is not
> giving me access to open the package also. it is giving me the error that
I[vbcol=seagreen]
> had written.
>
>
> "Uri Dimant" wrote:
>
We[vbcol=seagreen]
perticular[vbcol=seagreen]
but[vbcol=seagreen]
server[vbcol=seagreen]
Server[vbcol=seagreen]
server,[vbcol=seagreen]|||No there is no changes happend, I am able to Open the package and execute th
e
package from my client pc. But while doing the same on the sever console it
is giving me error. I am convienced that scheduler is not able to run the
package as server is giving the error.
This error is comming only on the Server's Enterprise Manager, not on any
client side.
"Uri Dimant" wrote:

> Well,that means that something was changed (an account, a password)
> Are you sure?
>
>
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:14BDAF90-AC4B-4C29-B459-0305DB6877DB@.microsoft.com...
> saved
> It
> I
> We
> perticular
> but
> server
> Server
> server,
>
>|||Still the only logical reason can be that there somehow is a difference
between your client and the server.
How do you log on on the server when you try to open the DTS via Enterprise
Mgr? Using your own account or rather via a (local) admin account on that
machine ?
If the latter, check if the sql-connection you speak about is based on a
Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
should verify (or even beter : try to simulate) the account used for
running the SQLAgent is able to connect to the requested database. Likely
something has changed the past week, they just forgot to tell you =)
Good Luck,
Roby
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...[vbcol=seagreen]
> No there is no changes happend, I am able to Open the package and execute
> the
> package from my client pc. But while doing the same on the sever console
> it
> is giving me error. I am convienced that scheduler is not able to run the
> package as server is giving the error.
> This error is comming only on the Server's Enterprise Manager, not on any
> client side.
> "Uri Dimant" wrote:
>|||In regards to the packages failing, you need to check the
job history for the DTS packages to determine why they are
failing. Checking the details in the job history will give
you more detailed information on why the packages are
failing to run as schedule.
-Sue
On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
<satyaki@.discussions.microsoft.com> wrote:

>We have got a SQL server 2000 loaded on a Windows 2000 advance server. We h
ad
>created some DTS on this server which were scheduled to run on perticular
>time. Few days back all the DTS started failing to execute through schedule
r.
>While checking from any client machine the DTS is running successfully but
on
>the server machine it is not. When I tried to open the DTS on the server
>console Enterprise Manager it is giving me following error
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL S
erver
>does not exists or access denied
>I had tried with reinstalling the SQL Enterprise manager on the server,
>reregistered the SQLDMO.dll but without any success.
>
>Can anybody help me'
>
>
>|||I had already checked that, it is giving same error server does not exists o
r
access denied. this is only happening on the server console enterprise
manager.
I don't thing it is any secured connection problem, nobody has change any
server configurations. Other activity on the enterprise manager is running
perfectly. I am facing this problem only on DTS package opening, may be due
to this the job scheduler is not running as job history is showing the same
problem.
"Sue Hoegemeier" wrote:

> In regards to the packages failing, you need to check the
> job history for the DTS packages to determine why they are
> failing. Checking the details in the job history will give
> you more detailed information on why the packages are
> failing to run as schedule.
> -Sue
> On Mon, 31 Jan 2005 02:09:06 -0800, "satyaki"
> <satyaki@.discussions.microsoft.com> wrote:
>
>|||i am using sa login in the server enterprise manager to open the DTS. i had
tried with windows authentication, DTS creators login but without any result
.
And no body has change any settings on the server/
"Roby Van Hoye" wrote:

> Still the only logical reason can be that there somehow is a difference
> between your client and the server.
> How do you log on on the server when you try to open the DTS via Enterpris
e
> Mgr? Using your own account or rather via a (local) admin account on that
> machine ?
> If the latter, check if the sql-connection you speak about is based on a
> Trusted Connection or on a SQL-login/pwd-connection. If it is trusted you
> should verify (or even beter : try to simulate) the account used for
> running the SQLAgent is able to connect to the requested database. Likely
> something has changed the past week, they just forgot to tell you =)
> Good Luck,
> Roby
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:33CC2F2F-EE23-46E1-AF5D-650C47170C98@.microsoft.com...
>
>

DTS job is not copying all the data but still the Job History shows Successful?

Hello everybody.
I've got 4 servers running Windows 2003 Standard edition with SQL 2000 SP3a.
On each SQL server there is a database that is copied to all the other
servers every night using a DTS scheduled job.
The database sizes are ranging from 50 Mb to 520 Mb.
Now the problem is that sometimes the job fails but it still reports
Successful in the Job History. The typical problem is that one ore more of
the tables on one of the destination server are empty. The table is there
but none of the records are there. The rest of the tables and their records
are fine.
Can anybody give me some hints as to how I can get a more detailed logging
of the process so we can investigate what is going wrong?
Martin Moustgaard
Job Shows Successfull of the Job ;
not the each data copy process..
Check ur DTS pack. is it well build. i mean the work flow of the package.. ?
What happens when a step in DTS raise Error , u handle this ?
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hello everybody.
> I've got 4 servers running Windows 2003 Standard edition with SQL 2000
SP3a.
> On each SQL server there is a database that is copied to all the other
> servers every night using a DTS scheduled job.
> The database sizes are ranging from 50 Mb to 520 Mb.
> Now the problem is that sometimes the job fails but it still reports
> Successful in the Job History. The typical problem is that one ore more of
> the tables on one of the destination server are empty. The table is there
> but none of the records are there. The rest of the tables and their
records
> are fine.
> Can anybody give me some hints as to how I can get a more detailed logging
> of the process so we can investigate what is going wrong?
> Martin Moustgaard
>
|||Martin
I'd run DTS from Data Transformation Services.
See what is going on , what task is failed.
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hello everybody.
> I've got 4 servers running Windows 2003 Standard edition with SQL 2000
SP3a.
> On each SQL server there is a database that is copied to all the other
> servers every night using a DTS scheduled job.
> The database sizes are ranging from 50 Mb to 520 Mb.
> Now the problem is that sometimes the job fails but it still reports
> Successful in the Job History. The typical problem is that one ore more of
> the tables on one of the destination server are empty. The table is there
> but none of the records are there. The rest of the tables and their
records
> are fine.
> Can anybody give me some hints as to how I can get a more detailed logging
> of the process so we can investigate what is going wrong?
> Martin Moustgaard
>
|||The DTS is actually very simple.
I only have a Copy SQL Server Objects Task in the package that is set up to
create destination objects (drop destination object first, include all
dependent objects, include extended properties), copy data (replace existing
data), use collation, copy all objects. Under options I've selected
everything except the 3 selections under secirity options.
The only error handeling I have is that the DTS jopb is set to retry 2 time
with 30 minutes interval if it fails.
Martin Moustgaard
"Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Job Shows Successfull of the Job ;
> not the each data copy process..
> Check ur DTS pack. is it well build. i mean the work flow of the package..
?[vbcol=seagreen]
> What happens when a step in DTS raise Error , u handle this ?
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> SP3a.
of[vbcol=seagreen]
there[vbcol=seagreen]
> records
logging
>
|||That's the problem :-)
Every time I run it manually it works fine. And 90% of the time it also runs
fine at night at the scheduled job. So I haven't been able to reproduce it
by running the jobs manually.
Martin Moustgaard
"Uri Dimant" <urid@.iscar.co.il> skrev i en meddelelse
news:uSMRBykwEHA.1984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Martin
> I'd run DTS from Data Transformation Services.
> See what is going on , what task is failed.
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> SP3a.
of[vbcol=seagreen]
there[vbcol=seagreen]
> records
logging
>
|||May be a Table Lock while dropping this tables?
Or.. Check the Owner Of the Tables...
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:eAL0hYlwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> The DTS is actually very simple.
> I only have a Copy SQL Server Objects Task in the package that is set up
to
> create destination objects (drop destination object first, include all
> dependent objects, include extended properties), copy data (replace
existing
> data), use collation, copy all objects. Under options I've selected
> everything except the 3 selections under secirity options.
> The only error handeling I have is that the DTS jopb is set to retry 2
time[vbcol=seagreen]
> with 30 minutes interval if it fails.
> Martin Moustgaard
>
> "Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
> news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
package..[vbcol=seagreen]
> ?
more
> of
> there
> logging
>
|||A table lock is also what I'm thinking. But since the jobs are run at 2
o'clock in the morning there shouldn't be anybody working at that hour :-)
But the only way to find out if it is a table lock is to increase the
logging level on the DTS job and that is my problem since I don't know where
to do this.
Owner of the table shouldn't be a problem since it works fine most of the
time.
Martin Moustgaard
"Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
news:%23XB1zylwEHA.3376@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> May be a Table Lock while dropping this tables?
> Or.. Check the Owner Of the Tables...
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:eAL0hYlwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> to
> existing
> time
> package..
2000[vbcol=seagreen]
other
> more
>

DTS job is not copying all the data but still the Job History shows Successful?

Hello everybody.
I've got 4 servers running Windows 2003 Standard edition with SQL 2000 SP3a.
On each SQL server there is a database that is copied to all the other
servers every night using a DTS scheduled job.
The database sizes are ranging from 50 Mb to 520 Mb.
Now the problem is that sometimes the job fails but it still reports
Successful in the Job History. The typical problem is that one ore more of
the tables on one of the destination server are empty. The table is there
but none of the records are there. The rest of the tables and their records
are fine.
Can anybody give me some hints as to how I can get a more detailed logging
of the process so we can investigate what is going wrong?
Martin MoustgaardJob Shows Successfull of the Job ;
not the each data copy process..
Check ur DTS pack. is it well build. i mean the work flow of the package.. ?
What happens when a step in DTS raise Error , u handle this ?
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hello everybody.
> I've got 4 servers running Windows 2003 Standard edition with SQL 2000
SP3a.
> On each SQL server there is a database that is copied to all the other
> servers every night using a DTS scheduled job.
> The database sizes are ranging from 50 Mb to 520 Mb.
> Now the problem is that sometimes the job fails but it still reports
> Successful in the Job History. The typical problem is that one ore more of
> the tables on one of the destination server are empty. The table is there
> but none of the records are there. The rest of the tables and their
records
> are fine.
> Can anybody give me some hints as to how I can get a more detailed logging
> of the process so we can investigate what is going wrong?
> Martin Moustgaard
>|||Martin
I'd run DTS from Data Transformation Services.
See what is going on , what task is failed.
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hello everybody.
> I've got 4 servers running Windows 2003 Standard edition with SQL 2000
SP3a.
> On each SQL server there is a database that is copied to all the other
> servers every night using a DTS scheduled job.
> The database sizes are ranging from 50 Mb to 520 Mb.
> Now the problem is that sometimes the job fails but it still reports
> Successful in the Job History. The typical problem is that one ore more of
> the tables on one of the destination server are empty. The table is there
> but none of the records are there. The rest of the tables and their
records
> are fine.
> Can anybody give me some hints as to how I can get a more detailed logging
> of the process so we can investigate what is going wrong?
> Martin Moustgaard
>|||The DTS is actually very simple.
I only have a Copy SQL Server Objects Task in the package that is set up to
create destination objects (drop destination object first, include all
dependent objects, include extended properties), copy data (replace existing
data), use collation, copy all objects. Under options I've selected
everything except the 3 selections under secirity options.
The only error handeling I have is that the DTS jopb is set to retry 2 time
with 30 minutes interval if it fails.
Martin Moustgaard
"Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Job Shows Successfull of the Job ;
> not the each data copy process..
> Check ur DTS pack. is it well build. i mean the work flow of the package..
?
> What happens when a step in DTS raise Error , u handle this ?
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> > Hello everybody.
> >
> > I've got 4 servers running Windows 2003 Standard edition with SQL 2000
> SP3a.
> >
> > On each SQL server there is a database that is copied to all the other
> > servers every night using a DTS scheduled job.
> >
> > The database sizes are ranging from 50 Mb to 520 Mb.
> >
> > Now the problem is that sometimes the job fails but it still reports
> > Successful in the Job History. The typical problem is that one ore more
of
> > the tables on one of the destination server are empty. The table is
there
> > but none of the records are there. The rest of the tables and their
> records
> > are fine.
> >
> > Can anybody give me some hints as to how I can get a more detailed
logging
> > of the process so we can investigate what is going wrong?
> >
> > Martin Moustgaard
> >
> >
>|||That's the problem :-)
Every time I run it manually it works fine. And 90% of the time it also runs
fine at night at the scheduled job. So I haven't been able to reproduce it
by running the jobs manually.
Martin Moustgaard
"Uri Dimant" <urid@.iscar.co.il> skrev i en meddelelse
news:uSMRBykwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Martin
> I'd run DTS from Data Transformation Services.
> See what is going on , what task is failed.
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> > Hello everybody.
> >
> > I've got 4 servers running Windows 2003 Standard edition with SQL 2000
> SP3a.
> >
> > On each SQL server there is a database that is copied to all the other
> > servers every night using a DTS scheduled job.
> >
> > The database sizes are ranging from 50 Mb to 520 Mb.
> >
> > Now the problem is that sometimes the job fails but it still reports
> > Successful in the Job History. The typical problem is that one ore more
of
> > the tables on one of the destination server are empty. The table is
there
> > but none of the records are there. The rest of the tables and their
> records
> > are fine.
> >
> > Can anybody give me some hints as to how I can get a more detailed
logging
> > of the process so we can investigate what is going wrong?
> >
> > Martin Moustgaard
> >
> >
>|||May be a Table Lock while dropping this tables?
Or.. Check the Owner Of the Tables...
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:eAL0hYlwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> The DTS is actually very simple.
> I only have a Copy SQL Server Objects Task in the package that is set up
to
> create destination objects (drop destination object first, include all
> dependent objects, include extended properties), copy data (replace
existing
> data), use collation, copy all objects. Under options I've selected
> everything except the 3 selections under secirity options.
> The only error handeling I have is that the DTS jopb is set to retry 2
time
> with 30 minutes interval if it fails.
> Martin Moustgaard
>
> "Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
> news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
> > Job Shows Successfull of the Job ;
> >
> > not the each data copy process..
> >
> > Check ur DTS pack. is it well build. i mean the work flow of the
package..
> ?
> >
> > What happens when a step in DTS raise Error , u handle this ?
> >
> >
> > "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> > news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> > > Hello everybody.
> > >
> > > I've got 4 servers running Windows 2003 Standard edition with SQL 2000
> > SP3a.
> > >
> > > On each SQL server there is a database that is copied to all the other
> > > servers every night using a DTS scheduled job.
> > >
> > > The database sizes are ranging from 50 Mb to 520 Mb.
> > >
> > > Now the problem is that sometimes the job fails but it still reports
> > > Successful in the Job History. The typical problem is that one ore
more
> of
> > > the tables on one of the destination server are empty. The table is
> there
> > > but none of the records are there. The rest of the tables and their
> > records
> > > are fine.
> > >
> > > Can anybody give me some hints as to how I can get a more detailed
> logging
> > > of the process so we can investigate what is going wrong?
> > >
> > > Martin Moustgaard
> > >
> > >
> >
> >
>|||A table lock is also what I'm thinking. But since the jobs are run at 2
o'clock in the morning there shouldn't be anybody working at that hour :-)
But the only way to find out if it is a table lock is to increase the
logging level on the DTS job and that is my problem since I don't know where
to do this.
Owner of the table shouldn't be a problem since it works fine most of the
time.
Martin Moustgaard
"Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
news:%23XB1zylwEHA.3376@.TK2MSFTNGP12.phx.gbl...
> May be a Table Lock while dropping this tables?
> Or.. Check the Owner Of the Tables...
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:eAL0hYlwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> > The DTS is actually very simple.
> >
> > I only have a Copy SQL Server Objects Task in the package that is set up
> to
> > create destination objects (drop destination object first, include all
> > dependent objects, include extended properties), copy data (replace
> existing
> > data), use collation, copy all objects. Under options I've selected
> > everything except the 3 selections under secirity options.
> >
> > The only error handeling I have is that the DTS jopb is set to retry 2
> time
> > with 30 minutes interval if it fails.
> >
> > Martin Moustgaard
> >
> >
> > "Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
> > news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
> > > Job Shows Successfull of the Job ;
> > >
> > > not the each data copy process..
> > >
> > > Check ur DTS pack. is it well build. i mean the work flow of the
> package..
> > ?
> > >
> > > What happens when a step in DTS raise Error , u handle this ?
> > >
> > >
> > > "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> > > news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> > > > Hello everybody.
> > > >
> > > > I've got 4 servers running Windows 2003 Standard edition with SQL
2000
> > > SP3a.
> > > >
> > > > On each SQL server there is a database that is copied to all the
other
> > > > servers every night using a DTS scheduled job.
> > > >
> > > > The database sizes are ranging from 50 Mb to 520 Mb.
> > > >
> > > > Now the problem is that sometimes the job fails but it still reports
> > > > Successful in the Job History. The typical problem is that one ore
> more
> > of
> > > > the tables on one of the destination server are empty. The table is
> > there
> > > > but none of the records are there. The rest of the tables and their
> > > records
> > > > are fine.
> > > >
> > > > Can anybody give me some hints as to how I can get a more detailed
> > logging
> > > > of the process so we can investigate what is going wrong?
> > > >
> > > > Martin Moustgaard
> > > >
> > > >
> > >
> > >
> >
> >
>

DTS job is not copying all the data but still the Job History shows Successful?

Hello everybody.
I've got 4 servers running Windows 2003 Standard edition with SQL 2000 SP3a.
On each SQL server there is a database that is copied to all the other
servers every night using a DTS scheduled job.
The database sizes are ranging from 50 Mb to 520 Mb.
Now the problem is that sometimes the job fails but it still reports
Successful in the Job History. The typical problem is that one ore more of
the tables on one of the destination server are empty. The table is there
but none of the records are there. The rest of the tables and their records
are fine.
Can anybody give me some hints as to how I can get a more detailed logging
of the process so we can investigate what is going wrong?
Martin MoustgaardJob Shows Successfull of the Job ;
not the each data copy process..
Check ur DTS pack. is it well build. i mean the work flow of the package.. ?
What happens when a step in DTS raise Error , u handle this ?
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hello everybody.
> I've got 4 servers running Windows 2003 Standard edition with SQL 2000
SP3a.
> On each SQL server there is a database that is copied to all the other
> servers every night using a DTS scheduled job.
> The database sizes are ranging from 50 Mb to 520 Mb.
> Now the problem is that sometimes the job fails but it still reports
> Successful in the Job History. The typical problem is that one ore more of
> the tables on one of the destination server are empty. The table is there
> but none of the records are there. The rest of the tables and their
records
> are fine.
> Can anybody give me some hints as to how I can get a more detailed logging
> of the process so we can investigate what is going wrong?
> Martin Moustgaard
>|||Martin
I'd run DTS from Data Transformation Services.
See what is going on , what task is failed.
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Hello everybody.
> I've got 4 servers running Windows 2003 Standard edition with SQL 2000
SP3a.
> On each SQL server there is a database that is copied to all the other
> servers every night using a DTS scheduled job.
> The database sizes are ranging from 50 Mb to 520 Mb.
> Now the problem is that sometimes the job fails but it still reports
> Successful in the Job History. The typical problem is that one ore more of
> the tables on one of the destination server are empty. The table is there
> but none of the records are there. The rest of the tables and their
records
> are fine.
> Can anybody give me some hints as to how I can get a more detailed logging
> of the process so we can investigate what is going wrong?
> Martin Moustgaard
>|||The DTS is actually very simple.
I only have a Copy SQL Server Objects Task in the package that is set up to
create destination objects (drop destination object first, include all
dependent objects, include extended properties), copy data (replace existing
data), use collation, copy all objects. Under options I've selected
everything except the 3 selections under secirity options.
The only error handeling I have is that the DTS jopb is set to retry 2 time
with 30 minutes interval if it fails.
Martin Moustgaard
"Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Job Shows Successfull of the Job ;
> not the each data copy process..
> Check ur DTS pack. is it well build. i mean the work flow of the package..
?
> What happens when a step in DTS raise Error , u handle this ?
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> SP3a.
of[vbcol=seagreen]
there[vbcol=seagreen]
> records
logging[vbcol=seagreen]
>|||That's the problem :-)
Every time I run it manually it works fine. And 90% of the time it also runs
fine at night at the scheduled job. So I haven't been able to reproduce it
by running the jobs manually.
Martin Moustgaard
"Uri Dimant" <urid@.iscar.co.il> skrev i en meddelelse
news:uSMRBykwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Martin
> I'd run DTS from Data Transformation Services.
> See what is going on , what task is failed.
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:ux2wptkwEHA.1984@.TK2MSFTNGP14.phx.gbl...
> SP3a.
of[vbcol=seagreen]
there[vbcol=seagreen]
> records
logging[vbcol=seagreen]
>|||May be a Table Lock while dropping this tables?
Or.. Check the Owner Of the Tables...
"Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
news:eAL0hYlwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> The DTS is actually very simple.
> I only have a Copy SQL Server Objects Task in the package that is set up
to
> create destination objects (drop destination object first, include all
> dependent objects, include extended properties), copy data (replace
existing
> data), use collation, copy all objects. Under options I've selected
> everything except the 3 selections under secirity options.
> The only error handeling I have is that the DTS jopb is set to retry 2
time
> with 30 minutes interval if it fails.
> Martin Moustgaard
>
> "Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
> news:ulPtvvkwEHA.1204@.TK2MSFTNGP10.phx.gbl...
package..[vbcol=seagreen]
> ?
more[vbcol=seagreen]
> of
> there
> logging
>|||A table lock is also what I'm thinking. But since the jobs are run at 2
o'clock in the morning there shouldn't be anybody working at that hour :-)
But the only way to find out if it is a table lock is to increase the
logging level on the DTS job and that is my problem since I don't know where
to do this.
Owner of the table shouldn't be a problem since it works fine most of the
time.
Martin Moustgaard
"Melih SARICA" <melihsarica@.hotmail.com> skrev i en meddelelse
news:%23XB1zylwEHA.3376@.TK2MSFTNGP12.phx.gbl...
> May be a Table Lock while dropping this tables?
> Or.. Check the Owner Of the Tables...
>
> "Martin Moustgaard" <nospam_moustrup@.hotmail.com> wrote in message
> news:eAL0hYlwEHA.3620@.TK2MSFTNGP09.phx.gbl...
> to
> existing
> time
> package..
2000[vbcol=seagreen]
other[vbcol=seagreen]
> more
>