#title Integration Service
[[TableOfContents]]

SSIS 참 좋은 툴이다..
RAM가격도 많이 싸졌으니 64bit 올려놓고서 돌리면 아주 짱짱하것다..

==== 자료들 ====
 * {{{plink.exe -ssh -batch -l userid -pw password 192.168.0.101 hadoop fs -ls /}}} -------> plink.exe -ssh -batch -l 아이디 -pw 패스워드 호스트 명령어
 * [dtutl]
 * [hive - odbc vs ado.net]
 * [http://databaser.net/moniwiki/wiki.php/Xp_cmdshell%2BDtexec xp_cmdshell + dtexec]
 * [ssisdb query]
 * [string to binary]
 * [bit수 세기]
 * [ssis 프로젝트 백업하기]
 * [ssis에서 ssh 명령]
 * [https://docs.microsoft.com/en-us/sql/integration-services/scale-out/walkthrough-set-up-integration-services-scale-out Integration Services (SSIS) Scale Out]
 * http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/101240/ --> SSIS Deployments with SQL Server 2012
 * http://www.datastax.com/download/clientdrivers --> ODBC Driver for Hive, ODBC Driver for Cassandra (beta), DataStax C# Driver
 * [http://msdn.microsoft.com/ko-kr/library/ms345167.aspx 프로그래밍 방식으로 패키지 작성]
 * [ssis json]
 * [sftp 삽질기]
 * [http://blogs.msdn.com/b/mattm/archive/2012/12/06/deploy-ssis-2012-projects-using-catalog-deploy-project-stored-procedure.aspx Deploy SSIS 2012 projects using catalog.deploy_project Stored Procedure]
 * [http://blogs.msdn.com/b/mattm/archive/2012/09/19/ssis-with-alwayson.aspx SSIS with AlwaysOn]
 * [http://www.mssqltips.com/sqlservertip/2693/export-images-from-a-sql-server-table-to-a-folder-with-ssis/ Export images from a SQL Server Table to a Folder with SSIS]
 * [http://www.sqlis.com/sqlis/post.aspx?id=a6d4de99-caf2-473e-9663-354d17325fab Trash Destination Adapter]
 * [http://www.sqlis.com/sqlis/post.aspx?id=b895e44d-bd33-4e3e-ad5b-b31be3a736d5 Checksum Transformation]
 * [http://www.sqlis.com/sqlis/post.aspx?id=ed6a8927-596f-4509-ab73-48546ad4ca55 Data Generator Source Adapter]
 * [http://www.sqlis.com/sqlis/post.aspx?id=543a2422-e5ec-4c94-9730-1e26382536b4 Regular Expression Transformation]
 * [http://www.sqlis.com/sqlis/post.aspx?id=087141f2-b820-484c-bd6c-e9ce9844d0b6 Row Count Plus Transformation]
 * [http://www.sqlis.com/sqlis/post.aspx?id=a4c753cc-257b-4d1c-b18b-e0d82e74bb5f Row Number Transformation]
 * [http://www.sqlis.com/sqlis/post.aspx?id=59563053-79cc-4961-8b39-fbd629c645c9 File Watcher Task]
 * [attachment:IntegrationService/Optimized_Bulk_Loading_of_Data_into_Oracle.docx Optimized Bulk Loading of Data into Oracle]
 * [http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle-in-sql-server-2012.aspx CDC for Oracle in SQL Server 2012]
 * [http://blogs.msdn.com/b/mattm/archive/2008/12/30/ezapi-alternative-package-creation-api.aspx EzAPI – Alternative package creation API] --> ssis package를 프로그래밍 하여 만들 수 있다.
 * [http://www.pgoledb.com/ PostgreSQL OLEDB Provider]
 * [정규표현식 CSharp]
 * [SSIS - Split]
 * [http://sqlblog.com/blogs/davide_mauri/archive/2011/11/24/execute-a-ssis-package-in-sync-or-async-mode-from-sql-server-2012.aspx Execute a SSIS package in Sync or Async mode from SQL Server 2012]
 * [http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx What’s New in SSIS for SQL Server 2012 RC0]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/76439/ A C#.NET toolkit for writing SSIS Script Tasks]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/76438/ A VB.NET toolkit for writing SSIS Script Tasks]
 * [http://blogs.msdn.com/b/mattm/archive/2011/08/12/ssis-t-sql-api-overview.aspx SSIS T-SQL API Overview]
 * [http://blogs.msdn.com/b/mattm/archive/2011/08/04/the-project-and-parameter-object-model.aspx The Project and Parameter Object Model]
 * [http://www.sqlservercentral.com/articles/CLR/74160/ A CLR-resident JSON serializer/deserializer for SQL Server] [http://databaser.net/moniwiki_doc/JSON.SQL.zip source code download]
 * [http://sqlserver-training.com/sql-server-denali-integration-services-ssis-enhancement-video-tutorials/- SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials]
 * [http://msdn.microsoft.com/en-us/library/dd425070.aspx The Data Loading Performance Guide]
 * [http://www.microsoft.com/download/en/details.aspx?id=4123 Integration Services Balanced Data Distributor]
 * [JsonToXml]
 * [http://www.zero1design.com/2010/07/07/mongodb-and-ssis/ MongoDB and SSIS]
 * [http://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/ Consuming JSON Strings in SQL Server] attachment:IntegrationService/parseJSON.sql
 * [http://www.simple-talk.com/sql/learn-sql-server/how-to-import-data-from-html-pages/ How to Import Data from HTML pages]
 * [http://www.databasejournal.com/features/mssql/article.php/3927921/article.htm Managing Remote Processes Using Script Task]
 * [http://www.mssqltips.com/tip.asp?tip=2297&home How To Use Regular Expressions for Data Validation and Cleanup]
 * [http://sqlmetadata.codeplex.com/ SQL Server Metadata Toolkit 2008]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/71516/ Hidden SSIS Features: Word Wrapping Your Annotations And More]
 * [http://social.technet.microsoft.com/wiki/contents/articles/sql-server-integration-services-ssis.aspx TechNet Wiki]
 * [http://www.sqlis.com/sqlis/post/Data-Profiling-without-SSIS.aspx Data Profiling without SSIS] [http://datacleaner.eobjects.org/ DataCleaner]
 * [http://sqlsrvintegrationsrv.codeplex.com/releases/view/21238 Microsoft SQL Server Community Samples: Integration Services]
 * [패키지 호출 성능]
 * [http://www.sqlis.com/sqlis/post.aspx?id=140922bb-c132-48f6-aa8b-267dcb20124d Using the Script Component as a Conditional Split]
 * [http://www.sqlis.com/sqlis/post.aspx?id=7f76e2a3-0643-41ba-8c4c-f060d229e30c Import SSIS Project in Denali CTP1]
 * [SSIS - IP유효성체크 및 바이너리변환]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70980/ Creating Dynamic Outputs in SSIS to an SQL Database]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70995/ Top 10 SQL Server Integration Services Best Practices]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62678/ Sending scheduled SQL query results via HTML e-mail using SSIS]
 * [http://www.bidn.com/blogs/MikeDavis/ssis/155/passing-variable-values-from-parent-package-to-child-ssis Passing Variable Values from Parent Package to Child SSIS]
 * [점보프레임]
 * [SSIS - 대리키 만들기]
 * [SSIS - 컬럼정렬]
 * [SSIS - 캐시변환]
 * [SSIS - Tip]
 * [리틀 엔디안 vs 빅 엔디안]
 * attachment:IntegrationService/디스크모니터링_WMI.dtsx (SSIS 2008 R2) --> [디스크 모니터링]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70636/ SQL Server 2008,Windows 2008 x64 and Excel]
 * [http://www.sqlservercentral.com/articles/Execution+Logging/69858/ Copy-and-Paste SSIS Execution Monitoring with Failure-Alert Email]
 * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70345/ How to Access SSIS Remotely]
 * [SSIS - Excel 데이터 읽기]
 * [SSIS - 웹페이지 호출]
 * [SSIS - Exporting to Excel 2007 - .xslx vs. .xslb]
 * [SSIS - FileExists]
 * [SSIS - Lookup Between]
 * [SSIS - CodePage 변환]
 * [SSIS - Data Reader원본에서 동적쿼리 사용]
 * [SSIS - StringToBinary]
 * [SSIS - 날짜쪼개기]
 * [MySQL 주의사항]
 * [http://sqlblogcasts.com/blogs/jorg/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx SSIS – Unpack a ZIP file with the Script Task ]
 * [SSIS - IP To Binary4]
 * [SSIS - dtsx파일 구조분석]
 * [SSIS - 특정 폴더의 파일들에 변화 이벤트를 잡아내기]
 * [SSIS - OLEDB 원본]
 * [SSIS - ODBC 원본]
 * [SSIS - XML Query]
 * [SSIS - 스크립트 구성요소]
 * [ETL관련 유용한 링크들]
 * [Dim_Date]
 * [IP와 지역정보]
 * [attachment:“SQL_실행_작업”의_결과셋의_순서로_“Foreach_루프_컨테이너”를_돌리는_방법.docx "SQL 실행 작업" 의 결과셋의 순서로 "Foreach 루프 컨테이너" 를 돌리는 방법 ]
 * attachment:Extending_SSIS_with_Custom_Tasks.zip
 * [attachment:SSIS_파일삭제.zip SSIS 파일 삭제 템플릿]
 * [attachment:SSIS_디스크모니터링.zip SSIS 디스크 모니터링 템플릿]
 * [attachment:IntegrationService/ssis_template.zip SSIS 패키지 템플릿] [ssis로그뷰어]
 * [ftp 명령어와 배치파일로 파일받기]
==== Code Plex ====
 * [http://scd.codeplex.com/ SSIS Slowly Changing Dimension Component]
 * [http://ssisunit.codeplex.com/ ssisUnit]
 * [http://ssisloganalyzer.codeplex.com/ SSIS Log Analyzer]
 * [http://reportgeneratortask.codeplex.com/ SSIS ReportGeneratorTask]
 * [http://smstask.codeplex.com/ SSIS SMSTask]
 * [http://regextractor.codeplex.com/ RegExtractor SSIS Component]
 * [http://ssisdownloadfiletask.codeplex.com/ SSIS Download File Task]
 * [http://ssisdowngrade.codeplex.com/ SSISDowngrade]
 * [http://dtloggedexec.codeplex.com/ DTLoggedExec]
 * [http://ssisencodefiletask.codeplex.com/ SSIS Encode File Task]
 * [http://rdc.codeplex.com/ Replacing Data Conversion Component for SSIS]
 * [http://ranktransform.codeplex.com/ SSIS Rank Transform]
 * [http://eod.codeplex.com/ Error Output's Description]
 * [http://imagesource.codeplex.com/ SSIS ImageSource]
 * [http://runssisactivity.codeplex.com/ Run SSIS Package Workflow Activity]
 * [http://ssmsagentjobvbs.codeplex.com/ Execute a SQL Server Agent Job - SSIS Package]
 * [http://fluentetl.codeplex.com/ FluentETL - Data automation made easy for coders]
 * [http://downloadmailtask.codeplex.com/ Download Mail Task]
 * [http://biquality.codeplex.com/documentation ORAYLIS BI.Quality]
 * [http://xmlify.codeplex.com/ xmlify]
 * [http://iislogreader.codeplex.com/ IIS Log reader]
 * [http://mobilephoneassistant.codeplex.com/ MobilePhoneAssistant]
 * [http://normalisercomponent.codeplex.com/ Normaliser Component]

==== 참고자료 ====
 * [http://www.sqlservercentral.com/articles/SSIS/69931/ No SFTP Task Component in SSIS 2005/2008? No Problem!]
 * [http://www.sqlservercentral.com/articles/Data+Warehouse/69679/ HASHBYTES can help quickly load a Data Warehouse]
 * [http://www.databasejournal.com/features/mssql/article.php/3869561/article.htm New and Improved Functionality in SSIS 2008]
 * [http://www.pgoledb.com PostgreSQL Native OLEDB Provider]
 * [http://www.sqlservercentral.com/articles/SQL+Server+2005/68790/ Run SSIS packages from remote client with stored procedure]
 * [http://www.mssqltips.com/tip.asp?tip=1893&home SQL Server Integration Services (SSIS) - Design Best Practices]
 * [http://www.harding.edu/fmccown/vbnet_csharp_comparison.html#strings VB.NET and C# Comparison]
 * [http://blogs.msdn.com/mattm/archive/2009/11/13/handling-slowly-changing-dimensions-in-ssis.aspx Handling Slowly Changing Dimensions in SSIS]
 * [http://www.mssqltips.com/tip.asp?tip=1893 SQL Server Integration Services (SSIS) - Design Best Practices]
 * [http://www.mssqltips.com/tip.asp?tip=1867 SQL Server Integration Services (SSIS) - Best Practices - Part 2]
 * [http://www.mssqltips.com/tip.asp?tip=1840 SQL Server Integration Services (SSIS) - Best Practices - Part 1]
 * [http://ssisctc.codeplex.com/ SSIS Community Tasks and Components]
 * [attachment:Common_Codepages.docx Common Codepages] (출처: http://asp3wiki.wrox.com/wiki/i-3-0-common-codepages)
 * SQL Task에서 Oracle SP 호출 방법: {call 프로시져명(파라메터1,파라메터2)}
 * [http://www.mssqltips.com/tip.asp?tip=1787 How to Execute Oracle Parameterized Queries Using SQL Server Integration Services]
 * [http://www.sql-server-performance.com/articles/biz/How_to_Import_Data_From_Excel_2007_p1.aspx How to Import Data from Microsoft Office Excel 2007 to SQL Server 2005]
 * [http://dev.mysql.com/downloads/connector/net/6.0.html Download Connector/Net 6.0] (.Net 3.5 이상 필요, .Net 2.0은 5.x 버전 사용)
 * [http://www.ideaexcursion.com/2009/06/04/howto-connect-to-mysql-in-ssis/ HOWTO: Connect to MySQL in SSIS]
 * [http://www.sqlis.com/post/Logging-connection-strings.aspx Logging connection strings]
 * [http://sqlblog.com/blogs/peter_debetta/archive/2006/07/13/Using-XML-Data-Type-Methods-to-query-SSIS-Packages.aspx Using XML Data Type Methods to query SSIS Packages]
 * [http://www.sqlservercentral.com/articles/SSIS/64766/ SSIS Lookup using a Script Component]
 * [http://msdn.microsoft.com/en-us/library/bb895315.aspx Improving Incremental Loads with Change Data Capture]
 * [http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx Top 10 SQL Server Integration Services Best Practices]
 * [http://blogs.msdn.com/mattm/archive/2008/10/18/lookup-cache-modes.aspx Lookup cache modes]
 * [http://blogs.msdn.com/mattm/archive/2008/10/18/calculating-the-size-of-your-lookup-cache.aspx Calculating the size of your Lookup cache]
 * [http://www.intelligententerprise.com/showArticle.jhtml?articleID=202405400&pgno=1 The Subsystems of ETL Revisited]
 * [http://www.microsoft.com/korea/msdn/library/ko-kr/dev/aspdotnet/regexnet.aspx#regexnet_topic2 ASP.NET의 정규식]
 * [http://msdn.microsoft.com/en-us/library/ms141036.aspx Integration Services Data Types]
 * [http://www.mssqltips.com/tip.asp?tip=1448 Using the Script Component to Execute PL/SQL Code in an Oracle Package from SQL Server Integration Services (SSIS)]
 * [http://www.cozyroc.com/products.html CozyRoc SSIS+ 1.3 Library(우와~)]
 * [http://www.sqlservercentral.com/articles/Integration+Services/64133/ SSIS 2008 Data Profiler]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx SSIS: Data Profiling Task: Part 1 - Introduction ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-2-column-length-distribution.aspx SSIS: Data Profiling Task: Part 2 - Column Length Distribution ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-3-column-null-ratio.aspx SSIS: Data Profiling Task: Part 3 - Column Null Ratio ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-4-column-pattern.aspx SSIS: Data Profiling Task: Part 4 - Column Pattern ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-5-column-statistics.aspx SSIS: Data Profiling Task: Part 5 - Column Statistics ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/03/ssis-data-profiling-task-part-6-column-value-distribution.aspx SSIS: Data Profiling Task: Part 6 - Column Value Distribution ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/03/ssis-data-profiling-task-part-7-functional-dependency.aspx SSIS: Data Profiling Task: Part 7 - Functional Dependency ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/04/ssis-data-profiling-task-part-8-candidate-key.aspx SSIS: Data Profiling Task: Part 8 - Candidate Key ]
 * [http://blogs.conchango.com/jamiethomson/archive/2008/03/07/ssis-data-profiling-task-part-9-value-inclusion.aspx SSIS: Data Profiling Task: Part 9 - Value Inclusion ]
 * [http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008--ssis-data-profiling-task/ SQL Server 2008- SSIS Data Profiling task]