Changing a Connection in DTS Local packages

Many of our Local packages in Data Transformation Services has the job of
copying data from one database on one server to another database on another
server. The package typically has 2 Connections defined.
Now we want to move the "destination" database to a new server. Is there any
way this can be done without editing each package in the "Design Package"
GUI
Thanks in advance
Henrik.You can use UDL files for the connection; you can change the properties
programmatically; you can use the Dynamic Properties task to change settings
at runtime.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Henrik Hjøllund Hansen" <hh@.dlf.dk> wrote in message
news:bicqd4$2hmp$1@.news.cybercity.dk...
> Many of our Local packages in Data Transformation Services has the job of
> copying data from one database on one server to another database on
another
> server. The package typically has 2 Connections defined.
> Now we want to move the "destination" database to a new server. Is there
any
> way this can be done without editing each package in the "Design Package"
> GUI
>
> Thanks in advance
>
> Henrik.
>
>

Change Tracking VS Update Index

When creating a new Table Schedule, there is an option for a Job Type of
"Update Index". I though this was Change Tracking, but it doesn't seem to
be. I still had to manually select Change Tracking from the full text menu.
What is Update Index?
Thanks
It is, but change tracking has two modes:
1) update index is a scheduled update, ie you can update the index on demand
or as a scheduled job
2) update index in background - ie have it happen continuously
"Don Schilling" <fake@.ReplyToGroup.com> wrote in message
news:OMa3r$2PEHA.648@.TK2MSFTNGP10.phx.gbl...
> When creating a new Table Schedule, there is an option for a Job Type of
> "Update Index". I though this was Change Tracking, but it doesn't seem to
> be. I still had to manually select Change Tracking from the full text
menu.
> What is Update Index?
> Thanks

Change owner of Maintenance Plan

I know that you can change the owner of a job. How can I change the owner of
a maintenance plan?
As a follow up question, does it really matter from a technical or
functional perspective who owns the maintenance plan. The job owner can be
different and has technical implications per its owner. One of the reasons I
want to change the owner, is because the person that created these plans is
not longer in the role of managing databases. I would like to change the
owner to a generic account like 'sa' or to an appropriate active dba
individual.
Thanks
TimHi Tim,
A maintained plan is executed by means of SQL Server Job, so if you
change the owner in the Job it will reflect accordingly. An owner is
important because SQL Server Job needs proper authorization to expect steps
layer out in the plan/job.
Mohit K. Gupta
MCTS: SQL Server 2005
"timw86" wrote:
> I know that you can change the owner of a job. How can I change the owner of
> a maintenance plan?
> As a follow up question, does it really matter from a technical or
> functional perspective who owns the maintenance plan. The job owner can be
> different and has technical implications per its owner. One of the reasons I
> want to change the owner, is because the person that created these plans is
> not longer in the role of managing databases. I would like to change the
> owner to a generic account like 'sa' or to an appropriate active dba
> individual.
> Thanks
> Tim|||I don't believe you can - not in a support manner anyway.
And no...It doesn't matter. It's the job owner that matters.
-Sue
On Wed, 20 Jun 2007 06:11:01 -0700, timw86
<timw86@.discussions.microsoft.com> wrote:
>I know that you can change the owner of a job. How can I change the owner of
>a maintenance plan?
>As a follow up question, does it really matter from a technical or
>functional perspective who owns the maintenance plan. The job owner can be
>different and has technical implications per its owner. One of the reasons I
>want to change the owner, is because the person that created these plans is
>not longer in the role of managing databases. I would like to change the
>owner to a generic account like 'sa' or to an appropriate active dba
>individual.
>Thanks
>Tim

Change owner of Maintenance Plan

I know that you can change the owner of a job. How can I change the owner of
a maintenance plan?
As a follow up question, does it really matter from a technical or
functional perspective who owns the maintenance plan. The job owner can be
different and has technical implications per its owner. One of the reasons I
want to change the owner, is because the person that created these plans is
not longer in the role of managing databases. I would like to change the
owner to a generic account like 'sa' or to an appropriate active dba
individual.
Thanks
Tim
Hi Tim,
A maintained plan is executed by means of SQL Server Job, so if you
change the owner in the Job it will reflect accordingly. An owner is
important because SQL Server Job needs proper authorization to expect steps
layer out in the plan/job.
Mohit K. Gupta
MCTS: SQL Server 2005
"timw86" wrote:

> I know that you can change the owner of a job. How can I change the owner of
> a maintenance plan?
> As a follow up question, does it really matter from a technical or
> functional perspective who owns the maintenance plan. The job owner can be
> different and has technical implications per its owner. One of the reasons I
> want to change the owner, is because the person that created these plans is
> not longer in the role of managing databases. I would like to change the
> owner to a generic account like 'sa' or to an appropriate active dba
> individual.
> Thanks
> Tim
|||I don't believe you can - not in a support manner anyway.
And no...It doesn't matter. It's the job owner that matters.
-Sue
On Wed, 20 Jun 2007 06:11:01 -0700, timw86
<timw86@.discussions.microsoft.com> wrote:

>I know that you can change the owner of a job. How can I change the owner of
>a maintenance plan?
>As a follow up question, does it really matter from a technical or
>functional perspective who owns the maintenance plan. The job owner can be
>different and has technical implications per its owner. One of the reasons I
>want to change the owner, is because the person that created these plans is
>not longer in the role of managing databases. I would like to change the
>owner to a generic account like 'sa' or to an appropriate active dba
>individual.
>Thanks
>Tim

Change owner of Maintenance Plan

I know that you can change the owner of a job. How can I change the owner o
f
a maintenance plan?
As a follow up question, does it really matter from a technical or
functional perspective who owns the maintenance plan. The job owner can be
different and has technical implications per its owner. One of the reasons
I
want to change the owner, is because the person that created these plans is
not longer in the role of managing databases. I would like to change the
owner to a generic account like 'sa' or to an appropriate active dba
individual.
Thanks
TimHi Tim,
A maintained plan is executed by means of SQL Server Job, so if you
change the owner in the Job it will reflect accordingly. An owner is
important because SQL Server Job needs proper authorization to expect steps
layer out in the plan/job.
Mohit K. Gupta
MCTS: SQL Server 2005
"timw86" wrote:

> I know that you can change the owner of a job. How can I change the owner
of
> a maintenance plan?
> As a follow up question, does it really matter from a technical or
> functional perspective who owns the maintenance plan. The job owner can b
e
> different and has technical implications per its owner. One of the reason
s I
> want to change the owner, is because the person that created these plans i
s
> not longer in the role of managing databases. I would like to change the
> owner to a generic account like 'sa' or to an appropriate active dba
> individual.
> Thanks
> Tim|||I don't believe you can - not in a support manner anyway.
And no...It doesn't matter. It's the job owner that matters.
-Sue
On Wed, 20 Jun 2007 06:11:01 -0700, timw86
<timw86@.discussions.microsoft.com> wrote:

>I know that you can change the owner of a job. How can I change the owner
of
>a maintenance plan?
>As a follow up question, does it really matter from a technical or
>functional perspective who owns the maintenance plan. The job owner can be
>different and has technical implications per its owner. One of the reasons
I
>want to change the owner, is because the person that created these plans is
>not longer in the role of managing databases. I would like to change the
>owner to a generic account like 'sa' or to an appropriate active dba
>individual.
>Thanks
>Tim

Change maintenance plan owner

I encountered the same issue with the Maintenance Plan, when I made a change
to the MaintPlan, the Job changed to that of the owner of the MaintPlan.
According to some reading I have been doing, there really isn’t a way to
change the Maintenance Plan Owner yet, I do understand why the MaintPlan
owner needs to be changed. In my case, the old DBA has been moved to another
section and no longer have rights to the SQL Server yet, when a change is
made to the MaintPlan, the job defaults to his name and the job fails. Also,
if the person is no longer an employee of the company yet, he created the
plans under his account, the MaintPlan defaults to his account or the account
he used when in SQL.
What I did to change the Owner of all Maintenance Plans in SQL 2005 was, if
you use windows authentication in SQL “run as” the SQL account that is the
manager of SQL or connect to SQL using the SQL Account that manages your SQL.
From there, modify the Maintenance Plan, such as rename it, then rename it
back; the MaintPlan will assume the account you are using as the ‘owner’.
This may be tedious but it works…
"Jim Early" wrote:

> I would like to change the owner of several maintenance plans. I can't seem
> to find a way to that without recreating each plan while connected as the new
> owner. Is there a method similar to changing a job's owner via the job's
> properties or a database's by sp_changedbowner?
> Thanks
/*Here's how to change the owner of a maintenance plan to dbo in SQL Server
2005*/
--to find the name and owner of the maintenance plan
--select * from msdb.dbo.sysdtspackages90
--to find the sid you want to use for the new owner
--select * from sysusers
UPDATE
[msdb].[dbo].[sysdtspackages90]
SET
[ownersid] = 0x01
WHERE
[name] = 'MaintenancePlan'