hello, please try this code.

create table #tmp( Game VARCHAR(100),PlayId VARCHAR(100),Team VARCHAR(100),Player VARCHAR(100),[Event] VARCHAR(10))

insert into #tmp(Game,PlayId,Team,Player,[Event])

values(1,1,'','',''),

(1,2,'A','Frank',3),

(1,3,'A','John',2),

(1,4,'B','Michael',4),

(2,1,'','',''),

(2,2,'A','Craig',''),

(2,3,'B','Bill',2),

(2,4,'A','Tom',1)

select A.Game,PlayId,A.Team,Player,[Event] from(

select Game,PlayId,Team,Player,[Event],Row_number() over( order by Game) as Ord1 from #tmp where [Event]<>0

) A

inner...

Thank you so much Luis for your quick reply. I will try it and will let you know.

thanks again

Thanks Louis, I was looking for this. is it possible to bring value column in 4 row like this-

ShopWeekValue

AW13

AW13

AW13

AW12

thanks for your help

yes i know its because of calling the function. but is there any other way to call this function with help of join like cross join or any alternate solution....

Thanks for your reply. but the problem is that these External and Internal Columns are not fixed means they are dynamic. moreover the result should be like in shoring order....

Thanks for your reply. but the problem is that these External and Internal Columns are not fixed means they are dynamic. moreover the result should be like in shoring order....

its working fine.

Thanks for your help.

Thanks

Sneh

seperator for column are good semicolumn(;). I also have row seperator i.e. space. but you know in columns we can have space so we can't say this particular space is...

try using sql script task-

Dim filename As String

Dim appExcel As Object

Dim newBook As Object

...

please see the following link. I'm facing the same problem but in sql 2008 Environment

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/04a26579-1ce7-4583-afc4-f499e8539b98/

yes

even I checked, when I'm running in BIDS its fast. but if I run the job its slow. the destination has "table or view- fast load" max insert commit size...

Thanks for looking into this.

Fastloadmaxinsertcommitsize is 2147483647

Accessmode is openrowset using fastload

fastloadoption is TABLOCK,CHECK_CONSTRAINTS

Thanks

Sneh

Can you pls explain how can do i error logging in ssis.

Thanks for your reply.

but i'm getting error "potential lose of data while excuting the pkg". what i do:- 1st give IMEX=1 in connection string this time i got the...