Cov txheej txheem:

Kuv yuav debug SSIS Data Flow li cas?
Kuv yuav debug SSIS Data Flow li cas?

Video: Kuv yuav debug SSIS Data Flow li cas?

Video: Kuv yuav debug SSIS Data Flow li cas?
Video: I WILL PRETTY - "Kuv Yuav Handsome" HANDS BAND COVER (GIRL VERSION) | TREASURE 2024, Kaum ib hlis
Anonim

SSIS Tutorials: Debugging Data Flow

  1. Kauj ruam 1: Qhia koj tus kheej Data Flow Task . Saib cov duab hauv qab no rau cov qauv cov ntaub ntawv foov txoj hauj lwm .
  2. Kauj ruam 2: Txoj nyem rau ntawm Data Flow Path editor raws li qhia hauv daim duab hauv qab no.
  3. Kauj ruam 3: Nyem rau ntawm Ntxiv raws li qhia hauv daim duab saum toj no. ntxiv cov ntaub ntawv tus saib.
  4. Kauj ruam 4: Tom qab ntxiv cov ntaub ntawv viewer koj yuav pom me me saib icon nrog rau cov ntaub ntawv ntws txoj kev.

Raws li txoj cai, kuv yuav ua li cas debug ib txoj haujlwm SSIS Script?

Rau debug koj code Script ua haujlwm , teem tsawg kawg yog ib qho kev tawg ntawm cov cai, thiab tom qab ntawd kaw VSTA IDE kom khiav cov pob hauv SQL Server Data Tools (SSDT). Thaum lub pob ua tiav nkag mus rau hauv Script ua haujlwm , VSTA IDE rov qhib dua thiab qhia koj cov lej hauv hom nyeem nkaus xwb.

Qhov thib ob, kuv tuaj yeem pom qhov yuam kev hauv SSIS pob li cas? 3 Teb. Qhov tseeb, cov Saib -> yuam kev Sau npe yuav ua yeeb yam koj tej yam tsis ncaj ncees lawm nrog koj pob ntawm lub sijhawm tsim. Qhov koj tab tom pom ntawm Cov Kev Tshawb Fawb tab, cov ntaub ntawv khiav lub sijhawm, kuj tseem yuav muaj rau koj nyob rau hauv qhov tso zis qhov rai Saib -> Tso zis los yog Ctrl + Alt + O rau cov neeg uas nyiam keystrokes.

Ib yam li ib tug yuav nug, dab tsi yog tag nrho cov txheej txheem debugging hauv SSIS?

Debugging SSIS Pob

  • Muaj peb txoj kev debugging. Lawv yog:
  • Ib txwm: Kev ua tiav yog ib txwm raug tshem tawm thaum lub ntsiab lus tawg raug ntaus. Ntaus suav sib npaug rau: Kev tua raug tshem tawm thaum tsis muaj.
  • Cov no muaj txiaj ntsig zoo los tswj kev khiav ntawm ntau yam dej num hauv kev tswj kev khiav. Cov kev xaiv txwv: Muaj ob txoj haujlwm hloov pauv.

Koj yuav ua li cas los daws cov pob ua tsis tiav hauv SSIS?

Cov txheej txheem tseem ceeb rau kev daws teeb meem deployed pob khoom yog raws li hauv qab no:

  1. Catch thiab tuav cov pob yuam kev los ntawm kev siv cov neeg tuav kev tshwm sim.
  2. Khaws cov ntaub ntawv tsis zoo los ntawm kev siv cov khoom siv yuam kev.
  3. Taug qab cov kauj ruam ntawm kev ua tiav pob los ntawm kev siv txiav.

Pom zoo: