DTS Problem

Try removing it from your server, running a reg clean then
putting it back on and registering it.
Peter
"A man is never more truthful than when he acknowledges
himself a liar."
Mark Twain

>--Original Message--
>I'm getting the error message
>Server.CreateObject Failed
>when running a dts package. Been searching around, it
recommended
>re-registering the 5 dts*.dll files on the system.
>All but one re-registered without a problem, however, the
dtswiz.dll file
>didn't - I got this error message
>"dtswiz.dll was loaded, but the DllRegisterServer entry
point was not found.
>This file can not be registered."
>
>Thanks for any help.
>
>
>.
>
Thanks for getting back to me peter
Been looking for info on running a registry clean - any advice?
Rich
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c49ff0$10833c20$a601280a@.phx.gbl...[vbcol=seagreen]
> Try removing it from your server, running a reg clean then
> putting it back on and registering it.
> Peter
> "A man is never more truthful than when he acknowledges
> himself a liar."
> Mark Twain
>
> recommended
> dtswiz.dll file
> point was not found.

DTS PACKAGE NOT SCHEDULING

Hello,
Every time I schedule my DTS packages it goes back to the default. For some
reason it’s not scheduling @. all. Not receiving any error msgs. & It runs
fine manually. What can cause this?
Thanks for your help in advanced!
Thanks!
Nigel
Nigel
It looks like you create a DTS package with an account which is different
from an account that SQL Server Agent is running.
"Nigel" <Nigel@.discussions.microsoft.com> wrote in message
news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> Hello,
> Every time I schedule my DTS packages it goes back to the default. For
some
> reason its not scheduling @. all. Not receiving any error msgs. & It
runs
> fine manually. What can cause this?
> Thanks for your help in advanced!
> --
> Thanks!
> Nigel
|||Can it only run on the account SQL Server Agent is running on?
Cause I have admin rights to the account.
Thanks for your reply.
**********************************************
"Uri Dimant" wrote:

> Nigel
> It looks like you create a DTS package with an account which is different
> from an account that SQL Server Agent is running.
>
>
> "Nigel" <Nigel@.discussions.microsoft.com> wrote in message
> news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> some
> runs
>
>
|||You could just be running into a known display issue. After
you have scheduled the package, check the schedule through
the job under SQL Server Agent instead of through the
package. There is a problem where when checking the schedule
through the package, it will just always shows the default
date/time but this is just a display issue. The schedule
will be correct for the job itself.
The following article documents the issue:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480
-Sue
On Tue, 5 Apr 2005 07:11:03 -0700, "Nigel"
<Nigel@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Can it only run on the account SQL Server Agent is running on?
>Cause I have admin rights to the account.
>Thanks for your reply.
>**********************************************
>"Uri Dimant" wrote:

DTS PACKAGE NOT SCHEDULING

Hello,
Every time I schedule my DTS packages it goes back to the default. For some
reason itâ's not scheduling @. all. Not receiving any error msgs. & It runs
fine manually. What can cause this?
Thanks for your help in advanced!
--
Thanks!
NigelNigel
It looks like you create a DTS package with an account which is different
from an account that SQL Server Agent is running.
"Nigel" <Nigel@.discussions.microsoft.com> wrote in message
news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> Hello,
> Every time I schedule my DTS packages it goes back to the default. For
some
> reason it?s not scheduling @. all. Not receiving any error msgs. & It
runs
> fine manually. What can cause this?
> Thanks for your help in advanced!
> --
> Thanks!
> Nigel|||Can it only run on the account SQL Server Agent is running on?
Cause I have admin rights to the account.
Thanks for your reply.
**********************************************
"Uri Dimant" wrote:
> Nigel
> It looks like you create a DTS package with an account which is different
> from an account that SQL Server Agent is running.
>
>
> "Nigel" <Nigel@.discussions.microsoft.com> wrote in message
> news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> > Hello,
> > Every time I schedule my DTS packages it goes back to the default. For
> some
> > reason itâ's not scheduling @. all. Not receiving any error msgs. & It
> runs
> > fine manually. What can cause this?
> >
> > Thanks for your help in advanced!
> >
> > --
> > Thanks!
> > Nigel
>
>|||You could just be running into a known display issue. After
you have scheduled the package, check the schedule through
the job under SQL Server Agent instead of through the
package. There is a problem where when checking the schedule
through the package, it will just always shows the default
date/time but this is just a display issue. The schedule
will be correct for the job itself.
The following article documents the issue:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480
-Sue
On Tue, 5 Apr 2005 07:11:03 -0700, "Nigel"
<Nigel@.discussions.microsoft.com> wrote:
>Can it only run on the account SQL Server Agent is running on?
>Cause I have admin rights to the account.
>Thanks for your reply.
>**********************************************
>"Uri Dimant" wrote:
>> Nigel
>> It looks like you create a DTS package with an account which is different
>> from an account that SQL Server Agent is running.
>>
>>
>> "Nigel" <Nigel@.discussions.microsoft.com> wrote in message
>> news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
>> > Hello,
>> > Every time I schedule my DTS packages it goes back to the default. For
>> some
>> > reason it?s not scheduling @. all. Not receiving any error msgs. & It
>> runs
>> > fine manually. What can cause this?
>> >
>> > Thanks for your help in advanced!
>> >
>> > --
>> > Thanks!
>> > Nigel
>>

DTS PACKAGE NOT SCHEDULING

Hello,
Every time I schedule my DTS packages it goes back to the default. For some
reason it’s not scheduling @. all. Not receiving any error msgs. & It run
s
fine manually. What can cause this?
Thanks for your help in advanced!
Thanks!
NigelNigel
It looks like you create a DTS package with an account which is different
from an account that SQL Server Agent is running.
"Nigel" <Nigel@.discussions.microsoft.com> wrote in message
news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> Hello,
> Every time I schedule my DTS packages it goes back to the default. For
some
> reason its not scheduling @. all. Not receiving any error msgs. & It
runs
> fine manually. What can cause this?
> Thanks for your help in advanced!
> --
> Thanks!
> Nigel|||Can it only run on the account SQL Server Agent is running on?
Cause I have admin rights to the account.
Thanks for your reply.
****************************************
******
"Uri Dimant" wrote:

> Nigel
> It looks like you create a DTS package with an account which is different
> from an account that SQL Server Agent is running.
>
>
> "Nigel" <Nigel@.discussions.microsoft.com> wrote in message
> news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> some
> runs
>
>|||You could just be running into a known display issue. After
you have scheduled the package, check the schedule through
the job under SQL Server Agent instead of through the
package. There is a problem where when checking the schedule
through the package, it will just always shows the default
date/time but this is just a display issue. The schedule
will be correct for the job itself.
The following article documents the issue:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480
-Sue
On Tue, 5 Apr 2005 07:11:03 -0700, "Nigel"
<Nigel@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Can it only run on the account SQL Server Agent is running on?
>Cause I have admin rights to the account.
>Thanks for your reply.
> ****************************************
******
>"Uri Dimant" wrote:
>

DTS package

I am tring to back up my remote site's data to my computer here at home.

I use DTS wizard from EM and copy objects and data (is this correct?)

Then I choose to save the package as SQL package, give it a name and times to run etc.

However I can't find where it has saved if indeed it has.
I've looked under SQL server agent jobs and management local packages but it's not there.

I'm sure I'm doing it all wrong!

Thanks for any advice.

JBDid you create the package on Your computers Sql Server or on the Remote Server? I am sure that is the problem. Check both locations.|||Thanks Wes,

But.. how on earth do I create this on the remote Database?

JB

dts package

I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
Pls helpOriginally posted by dokeyemi
I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
Pls help

You could save it as files
or you can also backup all your databases included master and msdb and restore on your new server|||Originally posted by omiossec
You could save it as files
or you can also backup all your databases included master and msdb and restore on your new server

You mean save the files one by one individually? How about deploying them? Say I have 100 ++ DTS packages?|||Check out www.sqldts.com. Look in their downloads section for something called DTSBackup2000. I have used it in a development environment with a tremendous amount of success. I have not yet had the courage to try it in production, but I'm getting pretty close.

Regards,

Hugh Scott

Originally posted by dokeyemi
I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
Pls help