As per my intepretation of your question iv written this snippet..

hope it helps..

CREATE TABLE #ACCT(ACCOUNTID NVARCHAR(50),VALUE INT IDENTITY(1,1))

INSERT INTO #ACCT(ACCOUNTID)

SELECT '' UNION ALL

SELECT '' UNION ALL

SELECT '' UNION ALL

SELECT ''...

if you have the ORG_STATUS_CHANGE_IND column in your table you can directly use it in an Execute SQL task and use a select statement in the oledb source to load...

This Should help... Used Jeff Moden's running total method mentioned in the below mentioned article.

http://www.sqlservercentral.com/articles/T-SQL/68467/

SELECT *,0 AS [ORG_STATUS_CHANGE_IND] INTO #TMP FROM D_ORG_TEST ORDER BY 5

DECLARE @FLAG INT

DECLARE @CLUB_ID...

Thanks for the insight...

Thanks Koen for your reply.. however im not in a position to go for an alternative method in this case... and after breaking my head with that issue i found...

Im facing a similar issue as well... Im calling a SP inside an OLEDB source and the structure of the SP goes like this..

Create proc usp_procforssis

as

begin

Exec USP_Logwrite @param1,@param2,@param3

Select *...

to add.... These types of queries have variations, eg:

Select a.*,b.* from

TableA a,TableB b

where a.ColName *= b.ColName --"*=" implies a left outer join and "=*' implies a right outer...

It would be great if there was more information. for example, the table structure of "tasks" and some sample data.

Please see the article for more information on best practices...

If i more than 4 levels of nesting in the objects with dependencies the proc doesn work... any other alternatives?

"Catch all Lookup tables are the bane of my life.

I've lost count of how many times I've had to write queries which join to the same lookup table 10 or...

Excellent article... Especially the list!!!!

Excellent article... Especially the list!!!!

this is a better option... this works well for 3 columns... was developed by my friend.... good one...

create the below table

PIVOTTABLE

Col1varchar(100)

col2varchar(100)

Col3varchar(100)

create Proc Usp_PivotRep ...

Even this works....

SET ROWCOUNT 1

DELETE YOURTABLE

FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE B WHERE A.COLNAME=B.COLNAME) >1

WHILE @@ROWCOUNT >0

DELETE YOURTABLE

FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE B WHERE A.COLNAME=B.COLNAME...