Integration Services Catalog yog dab tsi?
Integration Services Catalog yog dab tsi?

Video: Integration Services Catalog yog dab tsi?

Video: Integration Services Catalog yog dab tsi?
Video: Leng Yang - Yog Vim Dab Tsi (Official Full Song | Nkauj Tawm Tshiab) 2020/05/24 2024, Kaum ib hlis
Anonim

Deploying Packages rau SQL Server Integration Services Catalog (SSISDB) The SSIS Catalog yog ib lub thawv database rau txhua pob khoom siv. Cov ntaub ntawv teeb tsa tau hloov nrog Environments. Deployed versions yog taug qab keeb kwm thiab ib pob tuaj yeem rov qab mus rau qhov kev xa tawm yav dhau los.

Yog li ntawd, kuv yuav qhib qhov Kev Pabcuam Kev Sib Koom Tes Li Cas?

Koj nkag mus rau SSISDB catalog hauv SQL Server Management Studio los ntawm kev txuas mus rau SQL Server Database Cav thiab tom qab ntawd nthuav tawm Integration Services Catalogs node hauv Object Explorer. Koj nkag mus rau SSISDB database hauv SQL Server Management Studio los ntawm kev nthuav dav Databases node hauv Object Explorer.

Qhov thib ob, kuv yuav siv pob SSIS li cas rau Kev Pabcuam Kev Sib Koom Tes? Right-click rau ntawm qhov SSIS Catalog Demo project npe nyob rau hauv Development Studio thiab xaiv cov Muab tso rau khoom noj khoom haus. Nyem rau ntawm lub pob Next nyob rau hauv Integration Services Deployment Wizard vaj huam sib luag. Sau lub npe ntawm tus neeg rau zaub mov thiab txoj hauv kev mus rau qhov catalog tsim thiab nyem Next. Nyem qhov Muab tso rau khawm.

Tib neeg kuj nug, lub hom phiaj ntawm SSIS catalog DB yog dab tsi?

SSIS yog lub platform rau kev sib koom ua ke cov ntaub ntawv thiab cov ntawv thov ua haujlwm. Nws nta cov ntaub ntawv khaws cia cov cuab yeej siv rau cov ntaub ntawv rho tawm, hloov pauv, thiab thauj khoom (ETL). Cov cuab yeej kuj tseem siv tau los ua kom muaj kev saib xyuas ntawm SQL Server databases thiab hloov tshiab rau cov ntaub ntawv lub voos xwmfab multidimensional.

SSIS pob ua tiav keeb kwm nyob qhov twg?

Ua-nyob rau hauv Qhia. Ntau cov ntawv ceeb toom tau tsim rau hauv SSMS thiab nug cov SSIS catalog. Qhov yooj yim tshaj los saib cov ntawv ceeb toom rau a pob yog mus right-click rau lub pob thiab xaiv Cov Ntawv Qhia ⇒ Cov Ntawv Qhia Txuj Ci ⇒ Txhua Qhov Kev Ua Haujlwm ( saib hauv qab screenshot). Daim ntawv ceeb toom txhua qhov kev ua tiav qhia tau hais tias pob execution keeb kwm.

Pom zoo: