Resetting DTS password

Hi all,
can anybody please how to reset passwords for an DTS? I need to edit and run
it...but the former DBA left without giving us the passwords...
Thanks,
TudorHi Tudor - I would change the owner of the package.
We run/own all our packages under a 'pretend' domain account reservd for
SQL - this is also the account that SQL and SQL agent run under.
Hope this helps.
"Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> can anybody please how to reset passwords for an DTS? I need to edit and
run
> it...but the former DBA left without giving us the passwords...
> Thanks,
> Tudor
>|||Doesn't help. I can't do that until i open the package...What I need is to
change the owner password of the dts...
Tudor
"Allen Davidson" <allen.davidson@.europe.mccann.com> wrote in message
news:eoaY3vhpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Hi Tudor - I would change the owner of the package.
> We run/own all our packages under a 'pretend' domain account reservd for
> SQL - this is also the account that SQL and SQL agent run under.
> Hope this helps.
> "Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
> news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> > can anybody please how to reset passwords for an DTS? I need to edit and
> run
> > it...but the former DBA left without giving us the passwords...
> >
> > Thanks,
> > Tudor
> >
> >
>|||Hi Tudor - in this case I think you are stuck.
The pakage will be stored in encrypted form and without the owner password I
don't think you can do anything (anything at all usefull) with it.
Allen
"Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
news:eG$U24hpEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Doesn't help. I can't do that until i open the package...What I need is to
> change the owner password of the dts...
> Tudor
>
> "Allen Davidson" <allen.davidson@.europe.mccann.com> wrote in message
> news:eoaY3vhpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> > Hi Tudor - I would change the owner of the package.
> >
> > We run/own all our packages under a 'pretend' domain account reservd for
> > SQL - this is also the account that SQL and SQL agent run under.
> >
> > Hope this helps.
> >
> > "Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
> > news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > > can anybody please how to reset passwords for an DTS? I need to edit
and
> > run
> > > it...but the former DBA left without giving us the passwords...
> > >
> > > Thanks,
> > > Tudor
> > >
> > >
> >
> >
>

Resetting DTS password

Hi all,
can anybody please how to reset passwords for an DTS? I need to edit and run
it...but the former DBA left without giving us the passwords...
Thanks,
Tudor
Hi Tudor - I would change the owner of the package.
We run/own all our packages under a 'pretend' domain account reservd for
SQL - this is also the account that SQL and SQL agent run under.
Hope this helps.
"Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> can anybody please how to reset passwords for an DTS? I need to edit and
run
> it...but the former DBA left without giving us the passwords...
> Thanks,
> Tudor
>
|||Doesn't help. I can't do that until i open the package...What I need is to
change the owner password of the dts...
Tudor
"Allen Davidson" <allen.davidson@.europe.mccann.com> wrote in message
news:eoaY3vhpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Hi Tudor - I would change the owner of the package.
> We run/own all our packages under a 'pretend' domain account reservd for
> SQL - this is also the account that SQL and SQL agent run under.
> Hope this helps.
> "Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
> news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> run
>
|||Hi Tudor - in this case I think you are stuck.
The pakage will be stored in encrypted form and without the owner password I
don't think you can do anything (anything at all usefull) with it.
Allen
"Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
news:eG$U24hpEHA.3520@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Doesn't help. I can't do that until i open the package...What I need is to
> change the owner password of the dts...
> Tudor
>
> "Allen Davidson" <allen.davidson@.europe.mccann.com> wrote in message
> news:eoaY3vhpEHA.1296@.TK2MSFTNGP12.phx.gbl...
and
>

Reset DTS Owner Password

I have a situation where a Developer created a DTS, put an
owner password
and an user password & Finally forgot both.
Developer requested me, if I could retrieve / reset the
password.
Even after spending a lot of time with BOL / Internet on
the same topic, I
could not solve this problem.
Whar are methods to RESET / CHANGE a DTS's OWNER / USER
passwords ?
And
Why can't "sysadmin" members reset a password of a DTS
without knowing the
original password? (I know they can reset login password
without knowing
password !! )
-- Amithttp://www.sqldts.com/default.aspx?212|||does reset owner.
I want to reset package owner password.
As owner password is not available with a sa, DTS Designer does not allow "s
a" to edit package / open package / schedule package.
-- amit

Required DLLs for SQL7 DTS

I've written a VB6 application that executes a DTS package on SQL7.

The application works perfectly in both Develop and Runtime environments from my system. But when deployed (with default DLLs)to the intended client, the application raises an exception when creating an instance of the DTS object, "Set oPkg = New DTS.Package". The exception says "it can't create and instance of the object" or something to that effect.

While trying to figure out the problem, I installed the application ( without the default DLLs ) on the SQL Server machine. Again, it ran without a problem.

Unfortunately, the SQL machine is not the intended client. All systems here are running W2K(SP2).

Can someone offer some advice?

Thanks,

PaulThere are a couple of rll's you need like dtspkg.rll - the following page should answer your questions:

page (http://www.dbforums.com/archive/43/2002/04/3/356646)|||Originally posted by rnealejr
There are a couple of rll's you need like dtspkg.rll - the following page should answer your questions:

page (http://www.dbforums.com/archive/43/2002/04/3/356646)

Thanks for your response. However I am using a DSN-less connection. So the page above really does not apply.

Any other ideas. My only other option is to incorporate the function of the DTS package into the VB application. I would really like to aviod this option if possible.

Thanks again,

Paul|||Have you included the reference that you are using within your vb project when you install on another machine ? There are probably x number of files that have been left out and/or have not been registered on the deployed machine. I wanted you to see the top half of the article I posted (not the bottom half - about the dsn connection). The top half focused on required files for deployment.

Let me know.

Reprocessing Question

I have 5 cubes. All use shared dimensions in the same Analysis Services
database. In a DTS package, I first fully rebuild the dimensions and the
structure, and, no dimension has the changing dimension property.
After all the dimensions are fully reprocessed, I fully reprocess each cube,
but leave off the 'Incrementally Update Dimensions' so it is not checked. The
question is, will the way I'm doing this still allow for the dimensional
changes to be reflected into the reprocessed cubes? I think it will, but I
need to know for sure...
Thanks!
Yup. That will do it. When you do a full process of a non-changing
dimension, all cubes and partitions which use that dimension are reset to
the "unprocessed" state and remain there until you reprocess them. When
reprocessing happens on the cubes and partitions, then the dimension changes
are reflected in the updated cubes.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:1200CE19-A967-41B9-827D-B3EB52AD45FF@.microsoft.com...
>I have 5 cubes. All use shared dimensions in the same Analysis Services
> database. In a DTS package, I first fully rebuild the dimensions and the
> structure, and, no dimension has the changing dimension property.
> After all the dimensions are fully reprocessed, I fully reprocess each
> cube,
> but leave off the 'Incrementally Update Dimensions' so it is not checked.
> The
> question is, will the way I'm doing this still allow for the dimensional
> changes to be reflected into the reprocessed cubes? I think it will, but I
> need to know for sure...
> Thanks!
|||Thanks for the response Dave. That's what I thought, I just needed a sanity
check from someone...
Tom
"Dave Wickert [MSFT]" wrote:

> Yup. That will do it. When you do a full process of a non-changing
> dimension, all cubes and partitions which use that dimension are reset to
> the "unprocessed" state and remain there until you reprocess them. When
> reprocessing happens on the cubes and partitions, then the dimension changes
> are reflected in the updated cubes.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tom" <Tom@.discussions.microsoft.com> wrote in message
> news:1200CE19-A967-41B9-827D-B3EB52AD45FF@.microsoft.com...
>
>

Reprocessing Question

I have 5 cubes. All use shared dimensions in the same Analysis Services
database. In a DTS package, I first fully rebuild the dimensions and the
structure, and, no dimension has the changing dimension property.
After all the dimensions are fully reprocessed, I fully reprocess each cube,
but leave off the 'Incrementally Update Dimensions' so it is not checked. Th
e
question is, will the way I'm doing this still allow for the dimensional
changes to be reflected into the reprocessed cubes? I think it will, but I
need to know for sure...
Thanks!Yup. That will do it. When you do a full process of a non-changing
dimension, all cubes and partitions which use that dimension are reset to
the "unprocessed" state and remain there until you reprocess them. When
reprocessing happens on the cubes and partitions, then the dimension changes
are reflected in the updated cubes.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:1200CE19-A967-41B9-827D-B3EB52AD45FF@.microsoft.com...
>I have 5 cubes. All use shared dimensions in the same Analysis Services
> database. In a DTS package, I first fully rebuild the dimensions and the
> structure, and, no dimension has the changing dimension property.
> After all the dimensions are fully reprocessed, I fully reprocess each
> cube,
> but leave off the 'Incrementally Update Dimensions' so it is not checked.
> The
> question is, will the way I'm doing this still allow for the dimensional
> changes to be reflected into the reprocessed cubes? I think it will, but I
> need to know for sure...
> Thanks!|||Thanks for the response Dave. That's what I thought, I just needed a sanity
check from someone...
Tom
"Dave Wickert [MSFT]" wrote:

> Yup. That will do it. When you do a full process of a non-changing
> dimension, all cubes and partitions which use that dimension are reset to
> the "unprocessed" state and remain there until you reprocess them. When
> reprocessing happens on the cubes and partitions, then the dimension chang
es
> are reflected in the updated cubes.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "Tom" <Tom@.discussions.microsoft.com> wrote in message
> news:1200CE19-A967-41B9-827D-B3EB52AD45FF@.microsoft.com...
>
>