SQL Server Indonesia User Groups Community Men-Deploy Custom Data Flow Component - drowned in code

SQL Server Indonesia User Groups Community

SQL Server Indonesia User Groups Community
Welcome to SQL Server Indonesia User Groups Community Sign in | Join | Help
in Search
Home Blogs Forum Photos Downloads

drowned in code

eat, sleep, breath, SQL

Men-Deploy Custom Data Flow Component

  • Copy assembly ke folder “%Program Files%\Microsoft SQL Server\100\DTS\PipelineComponents” untuk component SSIS 2008 atau ke folder “%Program Files%\Microsoft SQL Server\100\DTS\PipelineComponents” untuk component SSIS 2005

 01 - Copy to pipelinecomponents folder

  • Drag assembly dari folder PipelineComponents ke folder “%Windows%\Assembly”

 02 - Drag to GAC Folder

  • Buka Business Intelligence Development Studio, dan buat satu Integration Services Project

 03 - New SSIS Project

  • Di Package.dtsx tambahkan Data Flow Task dari toolbox

 04 - Add Data Flow Task

  • Di toolbox klik kanan dan pilih menu Choose Items

 05 - Toolbox

  • Pilih tab SSIS Data Flow Items, check component yang akan di-deploy, lalu klik OK

 06 - Choose Toolbox Items

  • Component akan muncul di toolbox
07 - Component on Toolbox
Published Jul 29 2008, 01:23 AM by si_hendrik
Filed under: , ,

Comments

No Comments

This Blog

Syndication

All About SQL

F.R.I.E.N.D.S.

SSIS Component
Powered by Community Server (Commercial Edition), by Telligent Systems