I do not want to run the entire data flow task again ...i just want to process only the tables failed in each task or total data flow task if...

Kramasamy...Thanks for the response but i am not sure if i understand you correctly and also there is an existing process for which i am trying to do enhancement...

Existing Process...

Step1:...

Phil..Thanks for the post i tried replacing CHAR(9) tab and empty space but not line feed and carriage return ...

Yes i did it didnt work ..any other suggestions would be helpful...

Brian...I need to create a package and schedule it as a job so it is not a one time process also i have 100 thousand rows ...any other suggestions would...

Thanks Lutz but can you explain in more what would be the adv and how it works if i unpivot it..

I did some changes in the registry file by giveing permissions to all users and tried again then i received the error

cannot get supported data types from the...

I did Steve so hopefully you can understand it now so tell me what am i doing is correct ?? or am i in the wrong way ..??

Thanks King ...u r the king it helped me out...

Cmon Steve do you think i havent tried i have tried all weekend i shall post even my queries its not like i tried ....but i am unable to figure...

Gotch u Thank You Guys...

I shall try to do that ...Thankz Lynn..

No Lynn...Nothing is Blocking it as there is only one SPID on the DB which i am running and there is nothing other than that ....i ran sp_who2 i got...

Wat i jus want to know is Is ther any way to hold the data ...or any kind of locks for data ....

Lynn...Actually i wasnt given the Permission to check the Showplan...

and moreover its not from a file when i am querying a DB from two tables its taking more time when...