SQL Question Requested!!!

[Darling999]

Evarainaa manahubhaavulu untey naa ee prasnaa ki samadham ivaagalarani vignyapti.... *u(

Nenu oka table ni Lock cheyyali Using SSIS, Dantlo data mottanni inko table ki transfer cehskuni tarvata delete cheyyali. Final ga malli Lock tiyyali. evarainaa koddina site untey padeyandi bhayya. Solution istey inkaa manchidi.

tittakandi baa pani lo kottaga joinn  ayya

[graham]

naku ssis radu but okasari idi chudu:
[url=http://www.eggheadcafe.com/software/aspnet/31065993/locking-in-ssis.aspx]http://www.eggheadcafe.com/software/aspnet/31065993/locking-in-ssis.aspx[/url]

[Darling999]

Thanks baa atleast reply ayinaa ichaa,..  migatha vallu assalu lite kada..

[Jambhalheart]

bro naku kuda SSIS radu........ nenu .net developer but naa vanthu krushi gaa tadu ni paiki leputhunnanu....

maa office DB team ni oka sari aduguthanu....

[graham]

[quote author=nenuVedava link=topic=164798.msg1979810#msg1979810 date=1299605215]
Thanks baa atleast reply ayinaa ichaa,..  migatha vallu assalu lite kada..
[/quote]
migatha vallani anatam deniki. evariki istamaina posts lo vallu untaru.

ee thread paiki leputhu undu, definite ga help dorukutundi... chaala mandi SQL folks unnaru ikkada..

[DHONI]

naaku SSIS raadu.... sSa_j@il sSa_j@il sSa_j@il

[Ranga_The_Donga]

delete chesina taruwatha lock ah......?? sCo_hmmthink sCo_hmmthink sCo_hmmthink....

can u b specific....

[manoghna]

Follow these steps inorder to trasfer data to other table....

1. in SSIS BI Studio you have to take "Data Flow Task" in Control Flow Tab.

2. After Double click on "Data Flow Task"  you will transfer to Data Flow Tab.

3. In Data Flow Tab you have to put "OLE DB Source" and "OLE DB Destination"

4. In "Ole DB Source", You have to Assign Connection of source DB and select Drop Down of "Data access mode"  as "SQL Command", there you can write you Query,

5. In "Ole DB Destination", You have to Assign Connection of Destination DB and select Drop Down of "Data access mode"  as "Table or view fast load", there you have to select Destination Table.




but locking gurinchi  sCo_hmmthink sCo_hmmthink sCo_hmmthink sCo_hmmthink

[Darling999]

[quote author=Ranga_The_Donga link=topic=164798.msg1979862#msg1979862 date=1299605764]
delete chesina taruwatha lock ah......?? sCo_hmmthink sCo_hmmthink sCo_hmmthink....

can u b specific....
[/quote] Antey data source nunhi staging ki vesaaka dantlo(Main table) unnadaanni delete cheyyali

[vaasu]

SSIS vachu kaani, ee question ki answer teliyadhu.
eppudu ilanti situation raledhu.

My Guess: when ur transfering data from Table A to Table B, u can see options in the Data Access Mode Dropdown list. instead of selecting "table or view", select "Sqlcommand" and write a sql command.

in the sql command start with locking the first table, then select statment and then removing the lock.

[color=red]Note: this is my guess. not sure whether it works. [/color]

[Darling999]

[quote author=meghana9 link=topic=164798.msg1979869#msg1979869 date=1299605856]
Follow these steps inorder to trasfer data to other table....

1. in SSIS BI Studio you have to take "Data Flow Task" in Control Flow Tab.

2. After Double click on "Data Flow Task"  you will transfer to Data Flow Tab.

3. In Data Flow Tab you have to put "OLE DB Source" and "OLE DB Destination"

4. In "Ole DB Source", You have to Assign Connection of source DB and select Drop Down of "Data access mode"  as "SQL Command", there you can write you Query,

5. In "Ole DB Destination", You have to Assign Connection of Destination DB and select Drop Down of "Data access mode"  as "Table or view fast load", there you have to select Destination Table.




but locking gurinchi  sCo_hmmthink sCo_hmmthink sCo_hmmthink sCo_hmmthink
[/quote]

Thanks Baa kaani naa main questionn Locking and unlocking ey.... data flow avtundi but before that I have to lock it

[vaasu]

[quote author=meghana9 link=topic=164798.msg1979869#msg1979869 date=1299605856]
Follow these steps inorder to trasfer data to other table....
1. in SSIS BI Studio you have to take "Data Flow Task" in Control Flow Tab.
2. After Double click on "Data Flow Task"  you will transfer to Data Flow Tab.
3. In Data Flow Tab you have to put "OLE DB Source" and "OLE DB Destination"
4. In "Ole DB Source", You have to Assign Connection of source DB and select Drop Down of "Data access mode"  as "SQL Command", there you can write you Query,
5. In "Ole DB Destination", You have to Assign Connection of Destination DB and select Drop Down of "Data access mode"  as "Table or view fast load", there you have to select Destination Table.
but locking gurinchi  sCo_hmmthink sCo_hmmthink sCo_hmmthink sCo_hmmthink
[/quote]
*=: kaani athaniki e steps anni telusu anukunta. idhi teliyakapothe ssis meedha pani cheyyaledu kada.  sHa_high5ing

[manoghna]

[quote author=John Cena link=topic=164798.msg1979897#msg1979897 date=1299606277]
*=: kaani athaniki e steps anni telusu anukunta. idhi teliyakapothe ssis meedha pani cheyyaledu kada.  sHa_high5ing
[/quote] @gr33d sHa_high5ing

[manoghna]

[quote author=John Cena link=topic=164798.msg1979883#msg1979883 date=1299606132]
SSIS vachu kaani, ee question ki answer teliyadhu.
eppudu ilanti situation raledhu.

My Guess: when ur transfering data from Table A to Table B, u can see options in the Data Access Mode Dropdown list. instead of selecting "table or view", select "Sqlcommand" and write a sql command.

in the sql command start with locking the first table, then select statment and then removing the lock.

[color=red]Note: this is my guess. not sure whether it works. [/color]
[/quote]instead of selecting table ..select 'sql command' in that

i think you can try this query inorder to lock that table

SET TRANSACTION ISOLATION LEVEL READ COMMITED
GO
BEGIN TRANSACTION
SELECT * FROM TABLE
COMMIT TRANSACTION

idhi source select chese apudu.. sql command lo use chesthe work avuthundemo  sCo_hmmthink sCo_hmmthink

[goli soda]

locking entabba.......  epudu ilantidi vinalede.....  sCo_hmmthink sCo_hmmthink sCo_hmmthink