Could Somebody please assist me here,

is it something possible?

any ideas

please,,,

Thanks in advace

dhani

Thank you Lynn for your advice,

sure i am on my way to working on, just in case

i will goahead with what kevin provided

Thanks again for your advice

dhani

Hi Kevin,

thank you veru much for your immediate response, could you please see the attached expected result,

if possible please get the results like that

i greatful to your help

thanks alot

best regards

dhani

hi jeff,

thank you,

the criteria is mainly on account number, which is part of or primary key,

please suggest to have pk at table level rather every time remove pk before proc...

Thank you Sean Lange

so by adding like this does help any way data retrival,

also one more doubt is, in this table (where i want to add primary key),

in...

hi lynn,

i tried this way, am i doing correct , please correct me, is the case statement logic is good? or do i need to check some otherway

please help me,...

hi laurie,

thanks alot for your response,

great idea i will try to learn the #temptables

but others please post any other ideas as well... please

i will follow this

best regards

asita

Hi brandie,

They are all individual data flow tasks in one single ssis package.

Thanks & Best Regards

asitti

Thanks for your response Brandie, Phil

i am really sorry for the confusion,

here is bit clear explanation...

all i am using is Data flow tasks, Execute SQL tasks together,

let say i have...

Hi Sean,

yeah you are correct.

but the thing is, we can take any assumption but the out put need to match

just require to get that outcome, it is really a weird...

Hi Adi,

Thanks for your response, actually one guy asked me to do it,

i think it will be colA is Ranking on territory,

for col2 it will be based on sales_amount...

Thank you george, for your input

mean while i am going with this

http://www.bidn.com/blogs/mikedavis/ssis/153/using-expression-ssis-to-save-a-file-with-file-name-and-date

thanks again for your immediate response george, i geratfult o yy

Thanks for all the man kind

i great full to al of you

hisakimatama

Luis Cazares

capnhector

Steven Willis

i got the answer from hisakimatama, when he gave his first reply, i am using...

Thanks phill

right now it is working based on what you said,

but let me come back, this is kindof manual process for now, it will be changed to full automatic

back to...

Thanks phil,

i am also on the same way, i added pk (identity column name rowID1) and i can generate another column with "D:\ssis\" + rowID1 + ".txt"

then here my recent...