Thanks Joe.

In the short term, I cannot change the DDL based on where we are in our development cycle. I heartily agree that the recursive approach is confusing (one...

My apologies vis-a-vis etiquette:

CREATE TABLE [dbo].[ancestor](

[id] [bigint] NOT NULL,

[parent_id] [bigint] NOT NULL,

[language_id] [int] NULL,

[level] [int] NULL,

[ctr] [int] NULL,

[total] [int] NULL

) ON [PRIMARY]

go

alter table ancestor add constraint pk_ancestor primary key clustered(id,parent_id)

go

insert...

Thanks Jeff. Thank confirmed both my suspicion and how recursion loop is defined.

I also too the function route

create function uf_mixed (@p_col varchar(max))

returns varchar(max)

as

begin

declare @lgth int, @ctr int, @found varchar(1), @v_col varchar(max), @nxt int

select @lgth = LEN(@p_col), @ctr = 1, @found =...

I was unaware of Health Check. I'll definitely check it out.

Thanks, Mark

This is pretty neat. As advertised, it installs really quickly and I'd envision it to be a handy back pocket tool. One question: Has anyone used it to logon to...

Hi BankaR,

I added this code in an ActiveX script at the top of my package:

For i = 1 to oPackage.Tasks.Count                                                  

' Verify that this task is a transformation task...

Good Article. I wish there was something like it when I first started doing portable DTS work.

Chalk me up as another fan of UDL and INI files.

To add to...

Thanks Phill

This seems to make the most sense to me.

I can loop around the steps looking at ExecutionStatus and ExecutionResult fairly easily. It seems like a constant loop would...