SQL help........SSIS staging tables usage method

[Ranga_The_Donga]

[quote author=Dookudu link=topic=220351.msg2716666#msg2716666 date=1312482469]
Add a execute sql task before transferring data.
The select statement should be like SELECT present_synch_dt  from syn
Store this present_synch_dt in variable Present_SynchTime
And then add dataflow job. In the select statement use where last_update_dt >= Present_SynchTime
After dataflow job update the present_synch_dt
[/quote]

inka konchem clarity kavali ba........

data flow job lo execute sql statement vunadhu ga........den how can i use select statements...and update.....

or if u r talking abt OLEDB source.....explain it clearly.....

[nenuinthe]

[quote author=Jeedeelu link=topic=220351.msg2716673#msg2716673 date=1312482559]
source lo updates vunnayi.........

look-up pedithe....each row look up chesukovatam vall time tesukuntundhii.......paina nunchi orders vachayi....

staging tables use chesi....insert and update cheyamannaru..... cry@fl cry@fl cry@fl cry@fl
[/quote]rakarakala ga cheyyochu bayya...okasari matladam eve....

[C Nation]

[quote author=Jeedeelu link=topic=220351.msg2716688#msg2716688 date=1312482770]
inka konchem clarity kavali ba........

data flow job lo execute sql statement vunadhu ga........den how can i use select statements...and update.....

or if u r talking abt OLEDB source.....explain it clearly.....
[/quote]dataflow job mundu okka execute sql task operation perform cheyyi baaa
google search cheyyi daani meedha. u will understand

[Ranga_The_Donga]

[quote author=Dookudu link=topic=220351.msg2716719#msg2716719 date=1312483129]
dataflow job mundu okka execute sql task operation perform cheyyi baaa
google search cheyyi daani meedha. u will understand
[/quote]

control flow lo execute sql thelusu ba.....data flow lo gurinchi edo chepthunavuga adhi ardham kala.... s%H# s%H# s%H#

[Ranga_The_Donga]

[quote author=BEZAWADA ROWDY link=topic=220351.msg2716698#msg2716698 date=1312482964]
rakarakala ga cheyyochu bayya...okasari matladam eve....
[/quote]

sure.... S%Hi S%Hi S%Hi

[C Nation]

[quote author=Jeedeelu link=topic=220351.msg2716752#msg2716752 date=1312483394]
control flow lo execute sql thelusu ba.....data flow lo gurinchi edo chepthunavuga adhi ardham kala.... s%H# s%H# s%H#
[/quote]data flow lo table to table kakunda sql select statement to table data transfer cheyyi baaa.