Cov txheej txheem:

Oledb hais kom ua hauv SSIS yog dab tsi?
Oledb hais kom ua hauv SSIS yog dab tsi?

Video: Oledb hais kom ua hauv SSIS yog dab tsi?

Video: Oledb hais kom ua hauv SSIS yog dab tsi?
Video: Ol' Dirty Bastard ft. Kelis - Got Your Money (Official Video) [Explicit] 2024, Hlis ntuj nqeg
Anonim

Cov OLE DB hais kom ua Kev hloov pauv yog siv los khiav ib nqe lus SQL rau txhua kab ntawm nws cov ntaub ntawv nkag mus rau ntxig, hloov kho lossis tshem tawm cov ntaub ntawv hauv lub rooj database. Kev hloov pauv muaj ib qho kev tawm tswv yim, ib qho tawm thiab ib qho kev ua yuam kev.

Tom qab ntawd, ib tus tuaj yeem nug, Oledb hauv SSIS yog dab tsi?

OLE IB Command Transformation hauv SSIS yog siv los khiav cov nqe lus SQL xws li INSERT, Hloov Kho, thiab DELETE cov lus hauv Cov Ntaub Ntawv Flow. CEEB TOOM: SSIS OLE DB Command Transformation nyeem ib kab ntawm ib lub sij hawm thiab siv SQL nqe lus ntawm kab ntawd. Yog li, qhov kev ua tau zoo yuav nyuaj siab yog tias cov kab ntau ntxiv.

Ib sab saum toj no, Lookup transformation hauv SSIS yog dab tsi? Cov Nrhiav kev hloov pauv hauv SSIS yog ib qho muaj zog thiab siv tau Kev hloov pauv ntawm SSIS los sib piv cov ntaub ntawv qhov chaw thiab qhov chaw. Nws lim tawm cov ntaub ntawv sib tw thiab tsis sib xws hauv cov chaw uas tau teev tseg. Cia peb tsim lub hauv paus ntsiab lus thiab ntxig cov ntaub ntawv rau hauv nws nrog cov lus nug hauv qab no.

Ntxiv mus, OLE DB yog dab tsi hauv SSIS?

Cov OLE DB Source in SSIS yog siv los rho tawm cov ntaub ntawv los ntawm ntau yam databases uas txhawb nqa OLE IB Kev sib txuas. Cov SSIS OLE DB Source siv cov OLE IB Connection Manager kom txuas nrog Database Tables lossis Views.

Kuv yuav teeb tsa Oledb kev sib txuas li cas?

Ntxiv thiab teeb tsa tus thawj tswj kev sib txuas OLE DB

  1. Nyob rau hauv Solution Explorer pane, right-click on Connection Managers thiab xaiv New Connection Manager.
  2. Hauv Add SSIS Connection Manager dialog, xaiv OLEDB, ces xaiv Ntxiv.
  3. Hauv Configure OLE DB Connection Manager dialog box, xaiv Tshiab.
  4. Rau lub npe server, sau localhost.

Pom zoo: