thursday'snotes
this site the web

SQL Server Integration Service Part 1

Elemen yang membentuk Integration Service project::

  1. Package: unit kerja yang didapatkan, dieksekusi, dan disimpan dalam msdb database atau XML File dengan eksensi .dstx
  2. Control Flow : berisi task dan container
  3. Data Flow :  Berisi sources, transformation, and destination
  4. Variable : digunakan untuk melalukan operasi dinamis seperti update kolom dan mengontrol control flow berulang
  5. Event Handler : menjalankan response untuk run time events untuk membantu monitoring dan merespon package


0 comments:

Post a Comment

 

Disclaimer

I do not claim any of these images as my own unless otherwise stated

The views and opinions expressed on this blog are 100% mine. If I claim or appear to be an expert on a certain topic or product or service area, I will only endorse products or services that I believe, based on my expertise, are worthy of such endorsement. Any product claim, statistic, quote or other representation about a product or service should be verified with the manufacturer or provide

About Thursday's Notes

This blog is a personal blog written and edited by me, and does not reflect the views of either employers and/or clients. This blog does not accept any form of cash advertising, sponsorship, or paid topic insertions.