Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
MikeHI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx
.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike|||There's no other option ' I don't want to rename my
DTS's, i have references to it.
>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
> news:14e5801c41c8e$87f3eba0$a001280a@.phx
.gbl...
>
>.
>|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ' I don't want to rename my
>DTS's, i have references to it.
>
>the Owner password.
>package.
>message
Showing posts with label assign. Show all posts
Showing posts with label assign. Show all posts
Wednesday, March 7, 2012
DTS owner password
Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
Mike
HI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike
|||There's no other option ? I don't want to rename my
DTS's, i have references to it.
>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>
>.
>
|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ? I don't want to rename my
>DTS's, i have references to it.
>
>the Owner password.
>package.
>message
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
Mike
HI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike
|||There's no other option ? I don't want to rename my
DTS's, i have references to it.
>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>
>.
>
|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ? I don't want to rename my
>DTS's, i have references to it.
>
>the Owner password.
>package.
>message
DTS owner password
Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
MikeHI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike|||There's no other option ' I don't want to rename my
DTS's, i have references to it.
>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>> Hi,
>> Can i assign a owner password to a especified package
>> without recreating the package ?
>> Thanks a lot
>> Mike
>
>.
>|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ' I don't want to rename my
>DTS's, i have references to it.
>
>>--Original Message--
>>HI,
>>Open the Package and use the option SAVE AS and provide
>the Owner password.
>>In this case you will need to give a new name for this
>package.
>>Thanks
>>Hari
>>MCDBA
>>"Mike" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>> Hi,
>> Can i assign a owner password to a especified package
>> without recreating the package ?
>> Thanks a lot
>> Mike
>>
>>.
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
MikeHI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike|||There's no other option ' I don't want to rename my
DTS's, i have references to it.
>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>> Hi,
>> Can i assign a owner password to a especified package
>> without recreating the package ?
>> Thanks a lot
>> Mike
>
>.
>|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ' I don't want to rename my
>DTS's, i have references to it.
>
>>--Original Message--
>>HI,
>>Open the Package and use the option SAVE AS and provide
>the Owner password.
>>In this case you will need to give a new name for this
>package.
>>Thanks
>>Hari
>>MCDBA
>>"Mike" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>> Hi,
>> Can i assign a owner password to a especified package
>> without recreating the package ?
>> Thanks a lot
>> Mike
>>
>>.
Friday, February 17, 2012
DTS Import not working after SP3a upgrade
I have a DTS package that is importing a fixed length file.
After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
allow me to assign more than 125 fixed length column positions.
After hitting the Finish & OK button it just wipes out the column
settings.
After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
allow me to assign more than 125 fixed length column positions.
After hitting the Finish & OK button it just wipes out the column
settings.
I've reinstalled both Personal & Developer edition. DTS will allow
more than 125 prior to the service pack.You may be seeing a side effect of installing SP3 and the problem seen by
others after aplying this SP is here. There is a fix
814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/defaul...KB;EN-US;814113
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"shinobi332" <darinmiller@.earthlink.net> wrote in message
news:afdc1036.0406011922.2359a387@.posting.google.c om...
> I have a DTS package that is importing a fixed length file.
> After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
> allow me to assign more than 125 fixed length column positions.
> After hitting the Finish & OK button it just wipes out the column
> settings.
> I've reinstalled both Personal & Developer edition. DTS will allow
> more than 125 prior to the service pack.|||That worked perfectly.
Thanks Allan!!!
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message news:<40bd7127$0$4589$db0fefd9@.news.zen.co.uk>...
> You may be seeing a side effect of installing SP3 and the problem seen by
> others after aplying this SP is here. There is a fix
> 814113 - FIX DTS Designer May Generate an Access Violation After You
> Install SQL Server 2000 SP3
> http://support.microsoft.com/defaul...KB;EN-US;814113
>
> --
> --
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "shinobi332" <darinmiller@.earthlink.net> wrote in message
> news:afdc1036.0406011922.2359a387@.posting.google.c om...
> > I have a DTS package that is importing a fixed length file.
> > After installing SP3a (on PERSONAL & DEVELOPER edition) it will not
> > allow me to assign more than 125 fixed length column positions.
> > After hitting the Finish & OK button it just wipes out the column
> > settings.
> > I've reinstalled both Personal & Developer edition. DTS will allow
> > more than 125 prior to the service pack.
Subscribe to:
Posts (Atom)