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

Rerunning package with Parallel tasks

Hello,

I have done a search and have read some of the posts, but am left more confused than before. I am fairly new to SSIS. Here is my situation and what i am trying to accomplish.

I have a package that has a sequence container, in which there are multiple SQL tasks (about 20) running in parallel. I have checkpoints enabled, and FailPackageOnFailure enabled as well. If the package fails, when i re-run the package it will run the last task as well as all the other tasks. What I am looking to accomplish is when the package is re-run, have the SQL tasks that failed ran and not the previous successful tasks.

I think the best way would be via disabling tasks on successful completion of a task, where it writes the name of the SQL task to a temp table, but I am skeptical.

Can anyone point me in a direction to help me accomplish what I am looking for please.

Thanks in Advance.

As far as best practices in a situation like this I wouldn't know. Not sure how long each SQL task takes but have you thought of making the sequence containter have the transaction property set to required. If the containter fails then it would rollback and wouldn't matter if it everything ran over again.

|||I thought about this, however, this package takes about a day and half to run. Thus if I have to start over again, then I have lost all that time. It is more feasible to re-start the package at the point the package failed...|||You could use what I'll call "hard" checkpointing. That is, before each phase that you'd like to be able to restart from, you issue an Execute SQL task to write to a table. How you implement it would be up to you, but basically something like this:

TASK1 > TASK2 > TASK3 > TASK4

WOULD BE:

SQL (select step from checkpoint table) > TASK1 > SQL (update checkpoint table with new step value) > TASK2 > SQL (update checkpoint table with new step value) > TASK3 > SQL (update checkpoint table with new step value) > TASK4 ........ > SQL (Reset checkpoint table with default value so that next run starts at beginning)

Basically, when you start the package, you select from the checkpoint table the step number contained within. Store this number in a variable. Then, using precedence constraints right before each TASK, you can evaluate that variable to decide if the task should be skipped or not.

When a task completes successfully, it moves on to an Execute SQL task to update the "step" value in the checkpoint table, so that if the next task fails, when the package is restarted it can resume where it left off.

Make sense?|||

Thanks for the reply Phil.

From what you are proposing above, it looks very similar to running packages in sequence, where you have one task run then update a sql table, then move onto the next task. Basically, isnt that the purpose of checkpoints- to log to a file a restart point, thus if you added checkpoints to all 4 tasks, and it failed on task 3 it would restart at 3?

Your idea did get me to think. Rather than use "TASK" in your diagram, what if I used Sequence containers with tasks in it. But it still raises the issue of what happens if a task in the sequence container fails, and when the package is re-run to only execute those tasks that failed (after they have been modified)..

Repost: just in case i can get an answer

Hello all I have a situation so far I have been unable to find a solution
I have 3 tables like so
CREATE TABLE [dbo].[Users] (
[UserID] [int] IDENTITY (1, 1) NOT NULL ,
[CustomerID] [int] NULL ,
[FullName] [varchar] (50) NULL ,
[UserName] [varchar] (50) NULL ,
[Password] [varchar] (50) NULL ,
[Email] [varchar] (50) NULL ,
[CreationDate] [smalldatetime] NULL ,
[LastLogon] [smalldatetime] NULL
)
CREATE TABLE [dbo].[Users2SecurityRights] (
[Users2SecurityRightID] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [int] NULL ,
[SecurityRightID] [int] NULL ,
[AssignedDate] [smalldatetime] NULL ,
[AssignedBy] [int] NULL
)
CREATE TABLE [dbo].[SecurityRights] (
[SecurityRightID] [int] IDENTITY (1, 1) NOT NULL ,
[SecurityRightName] [varchar] (50) NULL ,
[SecurityRightDescription] [varchar] (100) NULL
)
Now I have a stored procedure that will return a string with all the user
Security rights like so (Administrator, Ag, Ed, Cus)
CREATE PROCEDURE ReturnSecurityRights
(
@.UserID INT
)
as
BEGIN
DECLARE @.Count INT
DECLARE @.CountOfRows INT
DECLARE @.SecurityRights VARCHAR(100)
DECLARE @.SecurityRightsHolder VARCHAR(100)
DECLARE MCursor CURSOR
LOCAL
STATIC
FOR (SELECT SecurityRights.SecurityRightName FROM Users2SecurityRights
INNER JOIN SecurityRights ON Users2SecurityRights.SecurityRightID =
SecurityRights.SecurityRightID
WHERE USERID = @.UserID)
OPEN MCursor
SET @.Count = 1
SET @.CountOfRows = @.@.CURSOR_ROWS
SET @.SecurityRights = ''
WHILE @.Count <= @.CountofRows
BEGIN
FETCH MCursor
INTO @.SecurityRightsHolder
SET @.SecurityRights = @.SecurityRightsHolder + ',' + @.SecurityRights
SET @.Count = @.Count + 1
END
SELECT @.SecurityRights
CLOSE MCursor
DEALLOCATE MCursor
END
I know, I know why am i using cursors...
What I want is to query the Users Table and return a result set where the
return of the SP(ReturnSecurityRights) is inline with the fields of the
Users Table
In essence i want to be able to do this
SELECT *, (EXEC ReturnSecurityRights UserID) FROM Users
I understand that I need to use a select within a subquery, just not sure
how i can accomplish what i need.
I can do this programically through Code but I really would like SQL Server
to process this
Thanks All, Hope I was clear in what I want to accomplish, and thank you to
all that will help me find the way
LenLeonard Danao wrote:
> Hello all I have a situation so far I have been unable to find a
> solution I have 3 tables like so
> CREATE TABLE [dbo].[Users] (
> [UserID] [int] IDENTITY (1, 1) NOT NULL ,
> [CustomerID] [int] NULL ,
> [FullName] [varchar] (50) NULL ,
> [UserName] [varchar] (50) NULL ,
> [Password] [varchar] (50) NULL ,
> [Email] [varchar] (50) NULL ,
> [CreationDate] [smalldatetime] NULL ,
> [LastLogon] [smalldatetime] NULL
> )
> CREATE TABLE [dbo].[Users2SecurityRights] (
> [Users2SecurityRightID] [int] IDENTITY (1, 1) NOT NULL ,
> [UserID] [int] NULL ,
> [SecurityRightID] [int] NULL ,
> [AssignedDate] [smalldatetime] NULL ,
> [AssignedBy] [int] NULL
> )
> CREATE TABLE [dbo].[SecurityRights] (
> [SecurityRightID] [int] IDENTITY (1, 1) NOT NULL ,
> [SecurityRightName] [varchar] (50) NULL ,
> [SecurityRightDescription] [varchar] (100) NULL
> )
> Now I have a stored procedure that will return a string with all the
> user Security rights like so (Administrator, Ag, Ed, Cus)
> CREATE PROCEDURE ReturnSecurityRights
> (
> @.UserID INT
> )
> as
> BEGIN
> DECLARE @.Count INT
> DECLARE @.CountOfRows INT
> DECLARE @.SecurityRights VARCHAR(100)
> DECLARE @.SecurityRightsHolder VARCHAR(100)
> DECLARE MCursor CURSOR
> LOCAL
> STATIC
> FOR (SELECT SecurityRights.SecurityRightName FROM
> Users2SecurityRights INNER JOIN SecurityRights ON
> Users2SecurityRights.SecurityRightID = SecurityRights.SecurityRightID
> WHERE USERID = @.UserID)
> OPEN MCursor
> SET @.Count = 1
> SET @.CountOfRows = @.@.CURSOR_ROWS
> SET @.SecurityRights = ''
> WHILE @.Count <= @.CountofRows
> BEGIN
> FETCH MCursor
> INTO @.SecurityRightsHolder
> SET @.SecurityRights = @.SecurityRightsHolder + ',' + @.SecurityRights
> SET @.Count = @.Count + 1
> END
> SELECT @.SecurityRights
> CLOSE MCursor
> DEALLOCATE MCursor
> END
>
> I know, I know why am i using cursors...
> What I want is to query the Users Table and return a result set where
> the return of the SP(ReturnSecurityRights) is inline with the fields
> of the Users Table
> In essence i want to be able to do this
> SELECT *, (EXEC ReturnSecurityRights UserID) FROM Users
> I understand that I need to use a select within a subquery, just not
> sure how i can accomplish what i need.
> I can do this programically through Code but I really would like SQL
> Server to process this
http://www.sqlteam.com/item.asp?ItemID=2955
http://www.windowsitpro.com/SQLServ...5608/15608.html
http://www.stephenforte.net/owdasbl...>
15d6d813eeb8
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks :)
*** Sent via Developersdex http://www.examnotes.net ***