Cov txheej txheem:

SSIS Script yog dab tsi?
SSIS Script yog dab tsi?

Video: SSIS Script yog dab tsi?

Video: SSIS Script yog dab tsi?
Video: Automation with Python! Automatically Executing a Script (Windows 10) 2024, Kaum ib hlis
Anonim

Cov Tsab ntawv kev ua haujlwm yog ntau lub hom phiaj uas koj tuaj yeem siv rau hauv ib lub pob kom ua tiav yuav luag txhua qhov kev xav tau uas tsis tau ua tiav los ntawm cov dej num suav nrog Kev Sib Koom Tes.

Ib yam li ntawd, kuv yuav khiav ib tsab ntawv hauv SSIS li cas?

Configuring Script Task

  1. Muab cov ntawv kev cai uas ua haujlwm.
  2. Qhia meej txog txoj hauv kev hauv VSTA qhov project uas Cov Kev Pabcuam Kev Sib Koom Ua Haujlwm hu ua lub ntsiab lus nkag rau hauv Script ua haujlwm code.
  3. Qhia cov lus sau.
  4. Optionally, muab cov npe ntawm kev nyeem nkaus xwb thiab nyeem / sau cov hloov pauv rau siv hauv tsab ntawv.

Tsis tas li ntawd, hom lus twg tuaj yeem siv los ua haujlwm sau ntawv hauv SSIS? SSIS tso cai rau tus tsim tawm xaiv ntawm ob qhov sib txawv scripting lus : C# lossis Visual Basic (VB). Pom koj nyob qhov twg ua tau ua qhov kev xaiv no, poob a Script Task mus rau Control Flow tsim nto. Right-click lub Script Task thiab nyem Kho kom raug los ntawm cov ntawv qhia zaub mov.

Ua raws li qhov no, dab tsi yog tsab ntawv ua haujlwm hauv SSIS?

Cov SSIS Script Task muab ib qho kev xaiv los siv cov dej num uas tsis muaj los yog ua tau hauv cov SSIS toolbox (ob qho tib si hauv built-in Cov hauj lwm thiab transformations). Cov SSIS script task siv Microsoft VSTA (Visual Studio Tools for Applications) raws li cov cai ib puag ncig uas koj tuaj yeem sau C# lossis VB Tsab ntawv.

Dab tsi yog qhov txawv ntawm Script task thiab Script tivthaiv hauv SSIS?

Cov Script component tau teeb tsa rau ntawm nplooj ntawv Data Flow ntawm tus tsim qauv thiab sawv cev rau qhov chaw, hloov pauv, lossis qhov chaw hauv Data Flow txoj hauj lwm . A Script ua haujlwm tuaj yeem ua tiav yuav luag txhua lub hom phiaj txoj hauj lwm . A Script ua haujlwm khiav kev cai code ntawm qee lub sijhawm hauv pob ua haujlwm.

Pom zoo: