no..no.....i mean that there can be different Incidentid's for a transno....if anyone of the isvoid value is 0 then isvoid must be 0....if all the values are 1 then isvoid...

i'm not able to get the DTS.Varaibles...i don't know why..

thank you , and

i want to use that variable in a script component to assign to a local variable...how can i do that?

okie then temme the way to extract the data from AS400....Could you?

how to do that, Deepak?

yes that is working on, and in this case i used adddays(1) but i get the same value for all the records rather than incrementing..so i don't know where my...

i tried, but im bad at coding part....could you help me by showing some sample codings

in the same way, how to increment the datetime value using Script component?

thanks a lot....its very helpful...

its solved...

i used row_number() in query...

but how can we do this through SSIS

yeah...i already saw this page...

im searching for dynamic process of downloading the file...

Churl, we can use http connection manager in ssis...

we have that option...

i need this process dynamically...

Hi Churl,

i agree with you....im asking this question to the forum friends because i don't know how to get this done and even im a newbie....if their responses is like...

steve...

i don't have any db..may be i can do..but i am creating this package for dynamic process....i have only the excel sheet...i need to give this package to the client...so...

yes...

it must be done through SSIS...

i have a column name ISHOLIDAY in OLEDB..

also i need to check, if the datetime column value from excel sheet is january 1st or december...